| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering zeros in Excel
Hi, do a custom format to the column or cell containing the zip codes. Right click on the cell or culumn containing the zip codes, go to "format cells" select the "number" tab then select "custom". Enter your own costom format by simply typing in "00000". Excel will then retain the 0 at the begining of your zip code. Plasim -- Plasim ------------------------------------------------------------------------ Plasim's Profile: http://www.excelforum.com/member.php...o&userid=28909 View this thread: http://www.excelforum.com/showthread...hreadid=486525 |
| 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
