Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Imelda Imelda is offline
external usenet poster
 
Posts: 2
Default How to merge an Excel currency field into a merged doc with $ ,.0

$14,507.00 in Excel goes into the Word merged document as 14507
How do I bring the formatting with the data?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How to merge an Excel currency field into a merged doc with $ ,.0

Add a formatting switch to the merge field
\# "$,0.00"
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



"Imelda" wrote in message
...
$14,507.00 in Excel goes into the Word merged document as 14507
How do I bring the formatting with the data?



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
Nested Merge field saves as merged with first record in excel jenkusi Mailmerge 3 March 12th 07 08:31 PM
merge currency incl .00 from excel into word doc bamny Mailmerge 3 January 6th 06 06:52 AM
Currency fields in Access lose th currency format whn merged why PMasters Mailmerge 1 June 1st 05 08:13 PM
How do I format a merge field as Currency or %? hmj3b5 Mailmerge 1 February 22nd 05 08:07 AM
Currency in merge from Excel tony Microsoft Word Help 1 February 7th 05 11:59 PM


All times are GMT +1. The time now is 09:05 AM.

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"