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

  • Thread starter Thread starter Guest
  • Start date Start date
you must do one of two things, format the cell containing the zip code
to accept zip codes or format to text
 
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?
 
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.
 
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

Entering zip codes beginning with zero 2
Leading 0 in Mail Merge document 4
Changing ZIP code formats in Excel 2003 6
format cells as zip code not working 3
zip codes starting with 0 1
Excel 2007 is stupid dealing with zipcodes 2
look up zip code 4
zip codes become 0 after merge excel to word 1

Back
Top