Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Long Documents / November 2003

Tip: Looking for answers? Try searching our database.

Formatting currency

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lee - 25 Nov 2003 15:48 GMT
I have a table that I am populating with data from Excel.  
The table is created by using mail merge, and then I paste
the table into the longer document that I am working on.  
My problem is that the table contains two long columns of
numbers formatted as currency.  When it is merged to a
Word document, the columns retain the dollar sign, but
lose the comma separator for 1000, and it automatically
inserts spaces between the dollar sign and some of the
smaller dollar amounts.  For example, $  5.00 and $10000.  

Is there a way to apply the desired formatting to the
entire column?  Currently, I have to go in and fix each
cell manually, and that is very laborious.

Thanks, Lee
Suzanne S. Barnhill - 25 Nov 2003 16:24 GMT
Since you're using mail merge for this, you can add a numeric picture switch
to the mail merge field to force the desired formatting. Look at Word's Help
topic "Numeric Picture (\#) field switch" and experiment till you get the
combination that works.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Signature

Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


> I have a table that I am populating with data from Excel.
> The table is created by using mail merge, and then I paste
[quoted text clipped - 11 lines]
>
> Thanks, Lee
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.