If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mail merge figures starting w/ zero
Is there a way to mail merge an excel field that starts with a zero to my
word document ? Using Office 2007 |
#2
|
|||
|
|||
mail merge figures starting w/ zero
If the value is coming across as a number, then the best you can do is
use a numeric format to ensure a fixed number of digits. e.g. use alt-F9 to view yur field code, which will look somethin glike { MERGEFIELD myfield } (Delete any other stuff after "myfield") Then, if all your numbers should have, say, 5 digits, use { MERGEFIELD myfield \#00000 } (so a number that comes across as 123 would display as 00123) If you need to preserve the exact text you have in Excel, and that text has a variable number of digits, post back. Peter Jamieson http://tips.pjmsn.me.uk On 18/05/2010 14:00, Tom4200 wrote: Is there a way to mail merge an excel field that starts with a zero to my word document ? Using Office 2007 |
Thread Tools | |
Display Modes | |
|
|