Formatting cell time format

  • Thread starter Thread starter floodlanduk
  • Start date Start date
F

floodlanduk

I'm having real problems with Excel 97 when I format a Cell for time it
seems to put the date in as well I'm really confused is there something
I am doing wrong ??



------------------------------------------------




------------------------------------------------
 
Dear he / she;

It may sound simple and I expect you to have tried it, but did you try on
the menu :

Format | Cells | Custom and in type entered : mm:ss

This must make cell entries appear in the correct format.

Mark Rosenkrantz.

More Excel ? www.rosenkrantz.nl or (e-mail address removed)
 
I'm a he :p

nope still doesn't work

I set the format to mm:ss and when I enter in a time for instance

09:00 it changes the field to 20/01/1900 00:00:00

help!



------------------------------------------------




------------------------------------------------
 
I'm a he :p

nope still doesn't work

I set the format to mm:ss and when I enter in a time for instance

09:00 it changes the field to 20/01/1900 00:00:00

help!



------------------------------------------------




------------------------------------------------
Click to expand...

Check your regional settings.

When you enter a time, it needs to be entered using the same separator as is
specified in your regional settings as a Time Separator.

The formatting only affects the display of the result.


--ron
 
Back
Top