| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 not retaining formatting in mail merge operation
I am trying to do merge document with excel and word 2007 and the zip codes
drop the first zero, 01234 becomes 1234. I have tried formatting the cells with ALL the choices to no avail. Please help!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 not retaining formatting in mail merge operation
You could use a helper column with =TEXT(A1,"00000"), or otherwise there is
a process shown at http://support.microsoft.com/kb/320473. -- David Biddulph "Susan" wrote in message ... I am trying to do merge document with excel and word 2007 and the zip codes drop the first zero, 01234 becomes 1234. I have tried formatting the cells with ALL the choices to no avail. Please help!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 not retaining formatting in mail merge operation
Thank you for the link but unfortunately it doesn't work for Excel 2007 ...
how do you use the helper column =TEXT(A1,"00000") .... would I need to insert that for each entry? There are over 7000! Susan "David Biddulph" wrote: You could use a helper column with =TEXT(A1,"00000"), or otherwise there is a process shown at http://support.microsoft.com/kb/320473. -- David Biddulph "Susan" wrote in message ... I am trying to do merge document with excel and word 2007 and the zip codes drop the first zero, 01234 becomes 1234. I have tried formatting the cells with ALL the choices to no avail. Please help!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 not retaining formatting in mail merge operation
You can copy down the formula, you only have to type it once, if you insert
the help column adjacent to the original column you can type it in the first adjacent cell, press enter, then select that cell again, move the cursor to the lower right corner of that cell and when the thick cross changes to a thin double click and the formula will be automatically copied down as long as there are entries in the original column. Then while still selected copy all entries and paste special as values in place. Then after making sure it came out right delete the original column and now the help column will take it's place and keep the leading zeroes. -- Regards, Peo Sjoblom "Susan" wrote in message ... Thank you for the link but unfortunately it doesn't work for Excel 2007 ... how do you use the helper column =TEXT(A1,"00000") .... would I need to insert that for each entry? There are over 7000! Susan "David Biddulph" wrote: You could use a helper column with =TEXT(A1,"00000"), or otherwise there is a process shown at http://support.microsoft.com/kb/320473. -- David Biddulph "Susan" wrote in message ... I am trying to do merge document with excel and word 2007 and the zip codes drop the first zero, 01234 becomes 1234. I have tried formatting the cells with ALL the choices to no avail. Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I lose my number formatting in the mail merge? | Excel Discussion (Misc queries) | |||
| Maintaining currency formatting in a Mail Merge? | Excel Discussion (Misc queries) | |||
| Using Mail Merge in Excel 2007 | Excel Discussion (Misc queries) | |||
| Cell formatting in Mail Merge | Excel Discussion (Misc queries) | |||
| How do you keep Excel currency formatting during a mail merge? | Excel Discussion (Misc queries) | |||
Linear Mode
