How do I record (.468) time in Excel without it rounding to .5?

[SuperDav]

I need to record time to 0:00.001 and Excel keeps rounding to 0:00.0

[David Biddulph]

"SuperDav" <SuperDav@discussions.microsoft.com> wrote in message
news:4C35A91F-8DE9-492D-B52A-D968D1D02D51@microsoft.com...
>I need to record time to 0:00.001 and Excel keeps rounding to 0:00.0

Change format to mm:ss.000
--
David Biddulph

[SuperDav]

Thanks David! I see where I can set the format under custom to mm:ss.000,
where under the time you can only select mm:ss.0

Thanks again!

"David Biddulph" wrote:

> "SuperDav" <SuperDav@discussions.microsoft.com> wrote in message
> news:4C35A91F-8DE9-492D-B52A-D968D1D02D51@microsoft.com...
> >I need to record time to 0:00.001 and Excel keeps rounding to 0:00.0
>
> Change format to mm:ss.000
> --
> David Biddulph
>
>
>