View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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