| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering zeros in Excel
I am creating a simple excel document into which I want to place address
values such as Name, Street, Zip Code etc. Ultimately, I will do a Mail Merge with Word to create address labels. The problem: When I type into the field I have for zip codes, if the zip code starts with a zero (eg., 06787), Excel immediately deletes the zero and list the entry as "6787". I have tried to enable "zeros" in Tools/Options/View/Zero Values but can not get the program to allow the entry of "06787". What simple thing am I missing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
| I am entering data but it appears as a date in excel | Excel Worksheet Functions | |||
Threaded Mode
