excel does not accept "0" as the first zip code number?
 

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

excel does not accept "0" as the first zip code number?
 

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

excel does not accept "0" as the first zip code number?
 

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?

excel does not accept "0" as the first zip code number?
 

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?

excel does not accept "0" as the first zip code number?
 

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?