Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove leading apostrophes in Excel? | Excel Discussion (Misc queries) | |||
Click on Excel Doc Starts Excel but Excel does not Open the Doc. | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
How to export excel column into Access without losing the leading. | Excel Discussion (Misc queries) |