Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark Mark is offline
external usenet poster
 
Posts: 182
Default word/excel mail merge

My mail merge returns an monetary amount as 123000. instead of $123,00.00
How do i fix this
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
dave dave is offline
external usenet poster
 
Posts: 4
Default word/excel mail merge

On May 14, 1:13 pm, mark wrote:
My mail merge returns an monetary amount as 123000. instead of $123,00.00
How do i fix this



right click on the field, clikc on toggle field codes. make it look
like this MERGEFIELD your field name\#$,##0.00

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default word/excel mail merge

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



mark wrote:
My mail merge returns an monetary amount as 123000. instead of
$123,00.00 How do i fix this



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
word mail merge excel Nora Mailmerge 2 August 12th 06 05:53 AM
How to merge Excel chart for mass Word Mail Merge for employees hmboomer Mailmerge 3 June 9th 06 10:08 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM


All times are GMT +1. The time now is 02:42 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"