merging using excel and dropping the comma in numbers

[When merging, comma in number is droppin]

How can I bring over the full number such as 15,000 and have the comma
remain? When word merges, the comma is dropped and I end up with 15000.

 

[macropod]

Hi,

You can do this by adding a formatting (picture) switch to your mergefield. If you select the field and press Shift-F9, you should
see something like:
{MERGEFIELD xlNumber}
If you add '\# ,0' after your mergefield's name (I've use xlNumber), thus:
{MERGEFIELD xlNumber \# ,0}
your number will be output with the thousands separator.

For more information on this, , check out the formatting discussion in my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442


Cheers

 

[When merging, comma in number is droppin]

That did it. I was not sure how to put the formatting in but after a couple
of trys, it worked, thank you so much!

Hi,

You can do this by adding a formatting (picture) switch to your mergefield. If you select the field and press Shift-F9, you should
see something like:
{MERGEFIELD xlNumber}
If you add '\# ,0' after your mergefield's name (I've use xlNumber), thus:
{MERGEFIELD xlNumber \# ,0}
your number will be output with the thousands separator.

For more information on this, , check out the formatting discussion in my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442


Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

How can I bring over the full number such as 15,000 and have the comma
remain? When word merges, the comma is dropped and I end up with 15000.