How do I get excel to start a numberwith a zero as in a zip code?
 

When I type a zip code that starts with a zero into my xls database the zero
doesn't take.

How do I get excel to start a numberwith a zero as in a zip code?
 

albev

Formate as text or procede with an apostrophe '

Mike Rogers

"albev" wrote:

When I type a zip code that starts with a zero into my xls database the zero
doesn't take.

How do I get excel to start a numberwith a zero as in a zip co
 

Thanks Mike BUT if I format as text then the number may not be recognized as
a number and therefore will not produce the postal codes, ditto if i procede
with an apostrophe. I did find a way though that works fine - highlight the
column in which the zip goes and then under FORMAT - CELLS - SPECIAL - ZIP
CODE TYPE ok.

"Mike Rogers" wrote:


albev

Formate as text or procede with an apostrophe '

Mike Rogers

"albev" wrote:

When I type a zip code that starts with a zero into my xls database the zero
doesn't take.

How do I get excel to start a numberwith a zero as in a zip co
 

That will work if all you need if ZIP + 4

Zip Codes or parts of Zip codes are not used as numbers so preceding with an
apostrophe or pre-formatting to text has no deleterious effect.


Gord Dibben MS Excel MVP

On Wed, 3 Jan 2007 20:15:01 -0800, albev
wrote:

Thanks Mike BUT if I format as text then the number may not be recognized as
a number and therefore will not produce the postal codes, ditto if i procede
with an apostrophe. I did find a way though that works fine - highlight the
column in which the zip goes and then under FORMAT - CELLS - SPECIAL - ZIP
CODE TYPE ok.

"Mike Rogers" wrote:


albev

Formate as text or procede with an apostrophe '

Mike Rogers

"albev" wrote:

When I type a zip code that starts with a zero into my xls database the zero
doesn't take.