| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Printing zip codes that start with 0
I formatted the cell for zip codes and in Excel 2003, the 0 shows up but when
I try to mail merge into a Publisher document, it won't print the 0 in zip codes that start with 0. Please help |
|
#2
|
|||
|
|||
|
That's because Excel is only showing the leading zero because of the format.
Try preceding the data with a single apostrophe or pre-format the cells as text If this still doesn't work, try using the TEXT function to correct the data =TEXT(A2,"000000") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "ET13" wrote in message ... I formatted the cell for zip codes and in Excel 2003, the 0 shows up but when I try to mail merge into a Publisher document, it won't print the 0 in zip codes that start with 0. Please help |
|
#3
|
|||
|
|||
|
Thank you. The apostrophe worked!
"Nick Hodge" wrote: That's because Excel is only showing the leading zero because of the format. Try preceding the data with a single apostrophe or pre-format the cells as text If this still doesn't work, try using the TEXT function to correct the data =TEXT(A2,"000000") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "ET13" wrote in message ... I formatted the cell for zip codes and in Excel 2003, the 0 shows up but when I try to mail merge into a Publisher document, it won't print the 0 in zip codes that start with 0. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another (simpler?) printing problem | Excel Discussion (Misc queries) | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
| Start & End Dates in pivot table | Excel Discussion (Misc queries) | |||
| How do I add consecutive numbers but start over at break in the. | Excel Discussion (Misc queries) | |||
| Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Linear Mode
