[Tom4200]

Is there a way to mail merge an excel field that starts with a zero to my
word document ? Using Office 2007

[Peter Jamieson]

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

[johngill]

Originally Posted by Tom4200

Is there a way to mail merge an excel field that starts with a zero to my
word document ? Using Office 2007

Well sorry but not have much more information about it....