Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2010, 01:15 PM
mikecincotta mikecincotta is offline I need MS Word Mail Merge Help! Windows XP I need MS Word Mail Merge Help! Office 2007
Novice
I need MS Word Mail Merge Help!
 
Join Date: Oct 2010
Posts: 1
mikecincotta is on a distinguished road
Default I need MS Word Mail Merge Help!

I have a templated letter in MS Word and information stored in an Excel file.



The field I want merged is a dollar amount. For example, it displays on Excel like $2,104.10 but when it merges it displays $2104.1. How do I get it to add the comma and the 0? Not all amounts end in zero, some are $22,104.11 but display as 22104.11.

This is how the original looks.

"...company totaling $«Amount»."

I posted this question on another board and they suggested I use "{MERGEFIELD number \# $####,0.0}"

But I don't know how to format it correctly in the document to make it workto make the amount format correctly?? into there someway or another?
Reply With Quote
  #2  
Old 10-04-2010, 05:22 PM
mattdan mattdan is offline I need MS Word Mail Merge Help! Windows 7 I need MS Word Mail Merge Help! Office 2007
Novice
 
Join Date: Oct 2010
Posts: 2
mattdan is on a distinguished road
Default

Hi,

I had the same problem recently. I think you'll find this link will sort it out...

http://support.microsoft.com/kb/320473

Matt
Reply With Quote
Reply

Tags
mail merge help, ms word

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with mail merge in MS Word 2003 Dgbhunter Mail Merge 0 10-05-2009 03:16 PM
I need MS Word Mail Merge Help! Word 2007 Mail Merge halfempty Mail Merge 1 03-03-2009 07:45 PM
mail merge in word help jngovols Mail Merge 0 04-07-2008 05:40 AM
Word / Access - Mail Merge ibuilders Mail Merge 0 07-30-2007 06:18 PM
Word mail merge and formula mridley Mail Merge 0 04-30-2006 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft