custom formatting cells

[lisa & corinne]

we are trying to remember how to show 7 (type only the
seven in the cell) as .0007, by formatting the cell. we
have tried several different custom formats, non of which
have been sucessful....HELP!!

 

[Mark Graesser]

Tools>Options>Edit>Fixed Decimal

This will do this for the entire sheet, not just one cell.

Good Luck,
Mark Graesser
(e-mail address removed)

 

[corinne & lisa]

-----Original Message-----
Tools>Options>Edit>Fixed Decimal

This will do this for the entire sheet, not just one cell.

Good Luck,
Mark Graesser
(e-mail address removed)
.
thanks mark - we're morons.....and we're the two that

everyone else comes to for help.... <DUH>