Re: "Something" is overriding my Format!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 07/23/04


Date: Fri, 23 Jul 2004 22:31:56 +0200

Hi
goto 'Tools - Options - Edit' and ucheck 'Fixed decimals'

--
Regards
Frank Kabel
Frankfurt, Germany
Marcia wrote:
> Hi!   In our Excel time*** templates, the cells are formatted with
> the Number cell with 2 decimal places.   When the user types in their
> time (ie., 8 hours) and moves out of the cell, it should convert the
8
> to 8.00.   "Something" is overriding the format, however, because the
> 8 is changing to .80 instead.
>
> Does anyone know what is happening?
>
> Thanks!
>
> Jessi

Quantcast