| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First zero doesn't show up in zip code mail merge.
When I do a mail merge of an excel spreadsheet, the first zero doesn't show
up. The column has a zip code format, and the actual cell shows the zero, but the function bar does not. For example, 02561 will show up as 2561. Any ideas how to fix? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
First zero doesn't show up in zip code mail merge.
Try using a TEXT function in a helper column
=TEXT(A1,"00000") If this doesn't work, use the data created by this function and copy it and Paste Special...+Values to a column pre-formatted as text -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "DLencz" wrote in message ... When I do a mail merge of an excel spreadsheet, the first zero doesn't show up. The column has a zip code format, and the actual cell shows the zero, but the function bar does not. For example, 02561 will show up as 2561. Any ideas how to fix? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I fix loosing 1st digit in zip code in mail merge? | Excel Worksheet Functions | |||
| nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
| zip code with mail merge | Excel Discussion (Misc queries) | |||
| Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
| How do I input zeroes in a zip code for a mail merge? | Excel Worksheet Functions | |||
Linear Mode
