Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mailmerge zip codes
When I do an address mail merge from an Excel document, it takes any zip
codes that begin with 0 and removes the 0. I have tried changing the cell format on the Excel document to "Text", but this does not work. What is the trick? -- Ronnie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mailmerge zip codes
Options include:
1 Format the cell to text before you type the data into the cell, or 2 Prefix the data with an apostrophe, or 3 Use a helper column =TEXT(A2,"00000") if you want to format as 5 digis including any leading zeroes, or 4 Use field formatting codes in Word (http://support.microsoft.com/kb/304387), or 5 Alter the means of data transfer from Excel to Word (again see http://support.microsoft.com/kb/304387) -- David Biddulph "Ronnie" wrote in message ... When I do an address mail merge from an Excel document, it takes any zip codes that begin with 0 and removes the 0. I have tried changing the cell format on the Excel document to "Text", but this does not work. What is the trick? -- Ronnie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mailmerge zip codes
Ronnie
I usually get by using a helper column with =TEXT(A1,"0000000") where A1 has the orginal zip codes and you want 7 digits come what may Give it a try -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Ronnie" wrote in message ... When I do an address mail merge from an Excel document, it takes any zip codes that begin with 0 and removes the 0. I have tried changing the cell format on the Excel document to "Text", but this does not work. What is the trick? -- Ronnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge and Charts | Charts and Charting in Excel | |||
Currency missing after mailmerge | Excel Discussion (Misc queries) | |||
How do I perform mailmerge in Excel | Excel Discussion (Misc queries) | |||
can i use mailmerge to in excel like you would in word? | Excel Discussion (Misc queries) | |||
mailmerge | Excel Discussion (Misc queries) |