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

M

mhart210

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

RagDyeR

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!
=====================================================

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

Guest

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

Marcelo

its is format as number

format as a text

hth
regards from Brazil
Marcelo

"dennisp" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Zip codes in mail merge - first digit doesn't display in merge 1
format cells as zip code not working 3
Zip Code formatting problem 3
Leading 0 in Mail Merge document 5
look up zip code 4

Top