Leading zero missing when merging from Excel to Word...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lance - 14 Jan 2004 21:43 GMT

I'm merging a number field with a leading zero from Excel
2003 to Word 2003 and the leading zero doesn't appear on
the Word document. Is it possible to merge leading
zeros, and if so, what format should the field be in
Excel.

One other issue is that if I merge a dollar amount,
example, $1234.50, it only merges 1234.5. How do I get
it to merge 1234.50?

Thanks,

Lance

Reply to this Message

Graham Mayor - 15 Jan 2004 07:44 GMT

You can do both with formatting switches on the merge field - see
http://www.gmayor.com/formatting_word_fields.htm
You should also take a look at the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm merging a number field with a leading zero from Excel
> 2003 to Word 2003 and the leading zero doesn't appear on
[quoted text clipped - 9 lines]
>
> Lance

Reply to this Message

LBoughie - 15 Jan 2004 21:21 GMT

Thanks for the great tip! I actually needed assistance with this and I find your suggestion. One thing that I had to change on my end is the placement of the comma from the example you gave on your website. I am using Office XP

\# ",$#.00;(,$#.00)" on your sit

\# "$,#.00;($,#.00)" moved the comma in front of the dollar sign

Reply to this Message

Graham Mayor - 16 Jan 2004 07:31 GMT

The comma positioning is obviously a Windows language thing. My system is
configured for UK English and it works as entered, but the page provides the
basic premise for formatting. Note that in order to have a leading zero,
you'll need to replace that hash before the decimal with a zero.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Thanks for the great tip! I actually needed assistance with this and
> I find your suggestion. One thing that I had to change on my end is
[quoted text clipped - 4 lines]
>
> \# "$,#.00;($,#.00)" moved the comma in front of the dollar sign

Reply to this Message

Jeff - 21 Jan 2004 00:10 GMT

If you first save the numbers as text, you'll preserve the
leading and trailing zeros.

>-----Original Message-----
>I'm merging a number field with a leading zero from Excel
[quoted text clipped - 11 lines]
>Lance
>.

Reply to this Message