When merging from excell, how do I keep $ and no decimal

[Shelly Reiff]

I am trying to merge an Excell spreadsheet into Word. One of my columns, is
a computed figure title Total Contact. In Word, I want the number to be in
this format: $30,800. I can only get it to print in this format 30800.25.
How do I do this?

 

[sueg]

Shelly, Did you ever figure this out? I'm having the same problem, even if
I actually key the comma in the Excel file. I handled the "$" by including
it in my Word file.

 

[Doug Robbins - Word MVP]

Press Alt+F9 to toggle on the display of the field codes and inside the
closing } at the following formatting switch:

\# "$,0"

For more information, see "Formatting Word fields with switches" on fellow
MVP Graham Mayor's website at
http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Doug Robbins - Word MVP]

See response to Shelly's post.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Rich/rerat]

Shelly & Sueg

Add the switch to the mergefied so it will look like this:

{Mergefield Amount \# "$,0;($,0)"}


--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


Shelly, Did you ever figure this out? I'm having the same problem, even if
I actually key the comma in the Excel file. I handled the "$" by including
it in my Word file.

 

[seagull]

HI...
I also facing this problem when doing the data merge due with no decimal ,
it can be solve by edit the field with the formating switch,

just wonder izzit any better solution to solve this , coz i will be
repeating doing this mail merge with different data every months , so it's a
bit troublesome for me to edit my field one by one ,monthly ....

 

[Doug Robbins - Word MVP]

You do not have to do it monthly, you just do it the one time in the
mailmerge main document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[seagull]

Hi Doug ,

mean i jz update my< field> and add the switch once on my master file will
do rite ?

 

[Doug Robbins - Word MVP]

Yes, you just need to modify the fields in the mailmerge main document the
one time.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[seagull]

ok..thanks you very much ...Douh Robbins

Yes, you just need to modify the fields in the mailmerge main document the
one time.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP