Re: "Something" is overriding my Format!
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 07/23/04
- Next message: goLeafs: "How to determine cell format in different locals"
- Previous message: Frank Kabel: "Re: automatic highlight of row when cell expires"
- In reply to: Marcia: ""Something" is overriding my Format!"
- Next in thread: Marcia: "Re: "Something" is overriding my Format!"
- Reply: Marcia: "Re: "Something" is overriding my Format!"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: goLeafs: "How to determine cell format in different locals"
- Previous message: Frank Kabel: "Re: automatic highlight of row when cell expires"
- In reply to: Marcia: ""Something" is overriding my Format!"
- Next in thread: Marcia: "Re: "Something" is overriding my Format!"
- Reply: Marcia: "Re: "Something" is overriding my Format!"
- Messages sorted by: [ date ] [ thread ]