how can i get a cell to hold a zero in front of a digit ie. 01 or.

S

Southern Belle

I have tried checking the zero values box but still just takes the zero from
the front which I need for the table I am trying to plan. I don't want any
decimal points in front
 
N

Nick Hodge

You can do it three ways

1) If the 'number' you want to end up with is fixed length, say six
characters, then Format>Cells...>Custom>000000 will do it
2) Format the cells as text in advance of entry
3) Prefix with a single apostrophe ('). It will not show but will treat the
entry as text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
P

Peo Sjoblom

Use a custom numeric format like 00 or precede entry with an apostrophe or
format as text before you enter it

Regards,

Peo Sjoblom
 
Top