formatting a cell

D

Donna

I want to put the number 017904 in a cell and it truncates the 0. I was told
to put a '017904 and that works, but isn't there an easier way than
remembering to put the ' in front of the number?
 
B

Bob Phillips

Set the cell format to 000000

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top