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


"Robert Wong" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

[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

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> Use a custom format, and format the cells like this: h:mm:ss.000
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Robert Wong" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>>
>
>

[Biff]

Hi!

Use a format like:

hh:mm:ss.000

Biff

"Robert Wong" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>