Reply
 
Thread Tools Display Modes
  #1   Report Post  
PCOR
 
Posts: n/a
Default Mail merge dollar values

Hi
I am attemoting to merge an EXCEL file which contains a heading TOTAL
Under that total are dollar valaue such as 620.00 or 1234.34
My trouble is that the mail merge shows as 620(no 00) 1234.34 shows up OK
How do I add the 2 zeros when reequired
Thanks


--
Norton Professional 2004 says this email is clean...believe it


  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"PCOR" wrote in message
...
Hi
I am attemoting to merge an EXCEL file which contains a heading TOTAL
Under that total are dollar valaue such as 620.00 or 1234.34
My trouble is that the mail merge shows as 620(no 00) 1234.34 shows up OK
How do I add the 2 zeros when reequired
Thanks


--
Norton Professional 2004 says this email is clean...believe it



  #3   Report Post  
PCOR
 
Posts: n/a
Default

Many thanks for putting me on the right track

"Doug Robbins" wrote in message
...
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"PCOR" wrote in message
...
Hi
I am attemoting to merge an EXCEL file which contains a heading TOTAL
Under that total are dollar valaue such as 620.00 or 1234.34
My trouble is that the mail merge shows as 620(no 00) 1234.34 shows up OK
How do I add the 2 zeros when reequired
Thanks


--
Norton Professional 2004 says this email is clean...believe it





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
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 05:11 AM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 02:31 PM
Specifying CC: and BCC: Values for Mail Merge to Email Mark V Mailmerge 2 November 29th 04 04:55 PM


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

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

About Us

"It's about Microsoft Word"