Truncation??

[Robert Wong]

Hi there,

I want to enter this into a spreadsheet:

01:14:15.956

It truncates it to
14:16.0


Anyone know why? and how to turn that feature off?

Robert

 

[Anne Troy]

Use a custom format, and format the cells like this: h:mm:ss.000
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Biff]

Hi!

Use a format like:

hh:mm:ss.000

Biff

 

[Robert Wong]

Hi there,

I got the custom format.. Now how do I set the default to allow that format
HH:MM:SS.MS (where it's 00:00:00.000)

It's strange, Excel 2000, if I type in that text '00:00:00.000" it formats
it correct. Has something
changed in Excel 2003?

Robert