Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mail merge does not show leading zero in Zip Code
I can put leading zero by changeing the cell format, but when I rum mail
merge through and attach an Excel file, my leading zero are missing. For example, Newark, NJ 07102 (it will display and print 7102). It happens in all MS Office versions released after Office 2000. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mail merge does not show leading zero in Zip Code
Hi
one way: use a helper column with a formula such as =TEXT(A1,"00000") -- Regards Frank Kabel Frankfurt, Germany "Altaf Choudry" <Altaf schrieb im Newsbeitrag ... I can put leading zero by changeing the cell format, but when I rum merge through and attach an Excel file, my leading zero are missing. For example, Newark, NJ 07102 (it will display and print 7102). It happens in all MS Office versions released after Office 2000. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mail merge does not show leading zero in Zip Code
Debra Dalgleish posted this for a different question:
In the Mail Merge, after you select your Excel file as a data source, you should see a 'Confirm Data Source' dialog box. (If you don't see the dialog box, change the setting in Word -- under ToolsOptions, General -- add a check mark to 'Confirm Conversion at Open') From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your formatting will be retained. If you have to connect through a different source, you can format the fields in the Word document. For example, to specify a number of decimals: 1. In Word, in the Main Document, press Alt+F9 to view the field codes. 2. Find the field code for the number. It will look something like: { MERGEFIELD FieldName } 3. Add a switch, to format the number with two decimal places. For example: { MERGEFIELD FieldName \# "#,##0.00" } 4. Press Alt+F9 to hide the field codes. 5. Save the Main Document (I bet you could modify it for your situation.) Altaf Choudry wrote: I can put leading zero by changeing the cell format, but when I rum mail merge through and attach an Excel file, my leading zero are missing. For example, Newark, NJ 07102 (it will display and print 7102). It happens in all MS Office versions released after Office 2000. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mail merge does not show leading zero in Zip Code
Another way would be to fix them in place with a macro.
Fix up for 5 digit US zip codes (#fixUSzip5) http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 Format the column as text ahead of running the macro. For notes on Mail Merge see http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Frank Kabel" wrote in message ... Hi one way: use a helper column with a formula such as =TEXT(A1,"00000") "Altaf Choudry" <Altaf schrieb im... I can put leading zero by changing the cell format, but when I run mail merge through and attach an Excel file, my leading zero are missing. For example, Newark, NJ 07102 (it will display and print 7102). It happens in all MS Office versions released after Office 2000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading 0 in Mail Merge document | Excel Discussion (Misc queries) | |||
mail merge in excel/losing leading zero | Excel Discussion (Misc queries) | |||
First zero doesn't show up in zip code mail merge. | Excel Worksheet Functions | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) |