i am typing a name list. Some of the zipcodes start with a 0 (east coast).
Excel doesn't show the 0 and shows only 4 digits. How do I get it to show the
0

If these are all 5 digits then you could format via FormatCells...Custom as
00000 or you could pre-format the cells as text (Same route and select text
from the formatting list) or prefix with a single apostrophe '. It will hold
the 0 but will not display itself

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Bea VanKampen" <Bea wrote in message
...
i am typing a name list. Some of the zipcodes start with a 0 (east coast).
Excel doesn't show the 0 and shows only 4 digits. How do I get it to show
the
0

"Bea VanKampen" wrote:

i am typing a name list. Some of the zipcodes start with a 0 (east coast).
Excel doesn't show the 0 and shows only 4 digits. How do I get it to show the
0

Format the cells with FormatCellsSpecialZip Code