 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2008When merging from excell, how do I keep $ and no decimal
I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? Shelly, Did you ever figure this out? I'm having the same problem, even if I actually key the comma in the Excel file. I handled the "$" by including it in my Word file.  Signaturesg > I am trying to merge an Excell spreadsheet into Word. One of my columns, is > a computed figure title Total Contact. In Word, I want the number to be in > this format: $30,800. I can only get it to print in this format 30800.25. > How do I do this? See response to Shelly's post. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Shelly, Did you ever figure this out? I'm having the same problem, even > if [quoted text clipped - 9 lines] >> 30800.25. >> How do I do this? Shelly & Sueg Add the switch to the mergefied so it will look like this: {Mergefield Amount \# "$,0;($,0)"} SignatureAdd MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> Shelly, Did you ever figure this out? I'm having the same problem, even if I actually key the comma in the Excel file. I handled the "$" by including it in my Word file. Signaturesg "Shelly Reiff" wrote: > I am trying to merge an Excell spreadsheet into Word. One of my columns, > is [quoted text clipped - 3 lines] > 30800.25. > How do I do this? Press Alt+F9 to toggle on the display of the field codes and inside the closing } at the following formatting switch: \# "$,0" For more information, see "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I am trying to merge an Excell spreadsheet into Word. One of my columns, >is [quoted text clipped - 3 lines] > 30800.25. > How do I do this? HI... I also facing this problem when doing the data merge due with no decimal , it can be solve by edit the field with the formating switch, just wonder izzit any better solution to solve this , coz i will be repeating doing this mail merge with different data every months , so it's a bit troublesome for me to edit my field one by one ,monthly .... > Press Alt+F9 to toggle on the display of the field codes and inside the > closing } at the following formatting switch: [quoted text clipped - 12 lines] > > 30800.25. > > How do I do this? You do not have to do it monthly, you just do it the one time in the mailmerge main document. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > HI... > I also facing this problem when doing the data merge due with no decimal , [quoted text clipped - 24 lines] >> > 30800.25. >> > How do I do this? Hi Doug , mean i jz update my< field> and add the switch once on my master file will do rite ? > You do not have to do it monthly, you just do it the one time in the > mailmerge main document. [quoted text clipped - 27 lines] > >> > 30800.25. > >> > How do I do this? Yes, you just need to modify the fields in the mailmerge main document the one time. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Hi Doug , > [quoted text clipped - 36 lines] >> >> > 30800.25. >> >> > How do I do this? ok..thanks you very much ...Douh Robbins > Yes, you just need to modify the fields in the mailmerge main document the > one time. [quoted text clipped - 39 lines] > >> >> > 30800.25. > >> >> > How do I do this? |
Reply to this Message |
 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.