Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I input zip codes with a leading zero
I live in the NE where zip codes start with a zero. I have gone in and tried
all options under format cells. I even entered some coding that would let me input what I need and it did not work. I am trying to set up a mail merge in Microsoft Word (I have Microsoft Office 2003 Standard Edition) and all my zips show up without the leading zero. Please help! |
#2
|
|||
|
|||
format --text
|
#3
|
|||
|
|||
Tried that, thanks... still does not work!
"º¼ÖÝÈË" wrote: format --text |
#4
|
|||
|
|||
If you format the cell as text, then type in your zip code (with the leading
zero), it'll work. Alternate #1. Type your zip with a leading apostrophe: '01234 Alternate #2. Type your zip as a number, but give it a custom format of: 00000 Susan wrote: Tried that, thanks... still does not work! "º¼ÖÝÈË" wrote: format --text -- Dave Peterson |
#5
|
|||
|
|||
If your question is really about the format appearance in *WORD*, and *not*
XL's format itself, try this link: http://office.microsoft.com/en*-ca/...4951033.*aspx -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Susan" wrote in message ... Tried that, thanks... still does not work! "º¼ÖÝÈË" wrote: format --text |
#6
|
|||
|
|||
Let's try this again.
Don't know why the darned link doesn't work in the post when it works fine in my sheet? http://office.microsoft.com/en-ca/as...164951033.aspx -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... If your question is really about the format appearance in *WORD*, and *not* XL's format itself, try this link: http://office.microsoft.com/en*-ca/...4951033.*aspx -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Susan" wrote in message ... Tried that, thanks... still does not work! "º¼ÖÝÈË" wrote: format --text |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
what is the format for an input cell? | Excel Discussion (Misc queries) | |||
How do I retain leading zero zip code formatting when saving as a. | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
How do I match two cells and input a value in a different cell? | Excel Worksheet Functions |