My cell is formatted to General and I keep losing the number zero

W

WTT

I my excel spreadsheet I have a column for zip codes/postal codes. And since
I collect both US and European addresses, I formatted the cell for "General".
But when I have a zip code that the first number is zero, I lose the zero
when I either save or move to the next cell. Help?
 
D

Douglas J. Steele

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

You'd be best off posting your question to a newsgroup related to Excel.
However, try putting a single quote in front of the zip code to ensure that
it's treated as text, not numeric.
 
Top