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

[Guest]

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?

 

[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.

 

[CyberDwarf]

This is an Access group. Post your question to microsoft.public.excel

 

[Joseph Meehan]

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?

General is a "number" format type and as a number 0 [zero] at the
beginning has no meaning. Why not use a text format, after all all zip
codes US and international are text and not numbers.

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.