Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Conweb2 Conweb2 is offline
external usenet poster
 
Posts: 2
Default How do I format numbers merged from Excel in a Word 2007 table?

I am doing a mail merge between Excel 2007 and Word 2007. What is the command
to format the numbers that are being imported, so they appear as currency?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I format numbers merged from Excel in a Word 2007 table?

Typically,
a. use Alt-F9 to reveal the field codes. You should see something like
{ MERGEFIELD myamount }
or
{ MERGEFIELD myamount \*Mergeformat }

where "myamount" is the column name of your number.
b. delete \*Mergeformat if you see it, and type in a "numeric format
switch" so your field looks as follows:

{ MERGEFIELD myamount \#"$,0.00" }

In this case, $ is the currency sign, "," is the thousands separator set
up in regional options, and "." is the decimal point set up in regional
options. So substitute those values as necessary.

If you happen to have values in different currencies in the same column,
things are harder - ask again.

Peter Jamieson

http://tips.pjmsn.me.uk

On 02/04/2010 19:48, Conweb2 wrote:
I am doing a mail merge between Excel 2007 and Word 2007. What is the command
to format the numbers that are being imported, so they appear as currency?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format numbers merged from Excel in a Word 2007 table? Conweb2 Tables 1 April 2nd 10 10:06 PM
Rounding Up Numbers Merged from Excel into Word 2003 Wisconsin Cheesehead Microsoft Word Help 1 December 23rd 08 09:50 PM
Losing $ and , in numbers being merged from Excel into Word docume FlorencePS Mailmerge 1 November 12th 05 07:07 AM
How do I format numbers in a Word table, data merged from Excel CJDRUMACHOSE Tables 1 November 11th 05 03:28 PM
formatting numbers mail merged into Word table from an Excel Works Jeannie McQuaid Tables 1 July 27th 05 10:06 PM


All times are GMT +1. The time now is 04:36 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"