Why does Excel not accept a "0" as the first number of a 5 digit zip code?

you must do one of two things, format the cell containing the zip code
to accept zip codes or format to text


--
mhart210
------------------------------------------------------------------------
mhart210's Profile: http://www.excelforum.com/member.php...o&userid=26413
View this thread: http://www.excelforum.com/showthread...hreadid=567970

You could 'Custom Format' your cell(s) to:
00000

OR,
You could 'Special Format' your cells to:
Zip Code

OR
You could prefix your cell entry with an apostrophe ( ' )
Which is *not* displayed in the cell but can be seen in the formula bar

OR
You could *PRE* format your cells to
TEXT

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"dennisp" wrote in message
...
Why does Excel not accept a "0" as the first number of a 5 digit zip code?

Hi

Excel assumes that 5 digits is a number - and numbers don't have leading
zeroes. Format your cell as text and retype it, or precede the zip code with
'

Hope this helps.
Andy.

"dennisp" wrote in message
...
Why does Excel not accept a "0" as the first number of a 5 digit zip code?

its is format as number

format as a text

hth
regards from Brazil
Marcelo

"dennisp" escreveu:

Why does Excel not accept a "0" as the first number of a 5 digit zip code?