Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the zero falling off a zip code in excel?
I am doing a spreadsheet in excel and in the zip code field the zero is
falling off the front. it is 08015 and it keeps changing to 8015. can anyone tell me why? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the zero falling off a zip code in excel?
Excel eliminates leading 0s by default.
See this for help, http://groups.google.com/group/micro...c53a3fddb34000 , or format your cells as text. -- Brevity is the soul of wit. "Pam" wrote: I am doing a spreadsheet in excel and in the zip code field the zero is falling off the front. it is 08015 and it keeps changing to 8015. can anyone tell me why? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the zero falling off a zip code in excel?
Pre-format the cell(s) as TEXT or type a leading apostrophe before typing the
zip with the leading zero........ Vaya con Dios, Chcuk, CABGx3 "Pam" wrote: I am doing a spreadsheet in excel and in the zip code field the zero is falling off the front. it is 08015 and it keeps changing to 8015. can anyone tell me why? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the zero falling off a zip code in excel?
Numbers are just numbers to excel. And 1 = 00000000001, so it doesn't care and
won't show them--unless you do something special. #1. PRE-Format the cell as text (format|cells|number tab|Text) #2. Start your data entry with an apostrophe ('08015) #3. Give the cell a custom format (Format|Cells|number tab|custom category) 00000 or if you could have 9 digit zips: [99999]00000-0000;00000 Pam wrote: I am doing a spreadsheet in excel and in the zip code field the zero is falling off the front. it is 08015 and it keeps changing to 8015. can anyone tell me why? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
VB Code and Excel | Excel Worksheet Functions | |||
How can I make Excel display HTML code as text | Excel Discussion (Misc queries) |