ExcelBanter - How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx) (https://www.excelbanter.com/excel-discussion-misc-queries/65938-how-do-i-get-excel-not-erase-leading-zipcode-zero-eg-0xxxx.html)

Ted W.

How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx)

I am creating an address list in Excel. The field for zipcodes will not
allow me to type in a Zipcode when the first number is a zero. The zero is
erased by Excel when I go to the next address line.

Andrew Houghton

How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx)

Prefix it with an apostrophe '

"Ted W." wrote in message
...
I am creating an address list in Excel. The field for zipcodes will not
allow me to type in a Zipcode when the first number is a zero. The zero
is
erased by Excel when I go to the next address line.

All times are GMT +1. The time now is 07:10 AM.