 |
 | 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 / May 2005Formatting Number Values from Mail Merge
I am mailmerging from a .txt data source and I want to format the following number: 00677400 I want it to display 67.74 and that's it. I can't figure out a way to tailor my field to meet my criteria. Any ideas? Use a calculation field eg {=({Mergefield fieldname} / 10000)}  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I am mailmerging from a .txt data source and I want to format the > following number: 00677400 [quoted text clipped - 3 lines] > I can't figure out a way to tailor my field to meet my criteria. > Any ideas? When using {=({Mergefield fieldname} / 10000)} I get a syntax error. Do I have to covert it to a numerical value in some way before trying to divide it by 100000? It is pulling it from a .txt file. - Thanks, Jonathan > Use a calculation field eg > [quoted text clipped - 15 lines] > > I can't figure out a way to tailor my field to meet my criteria. > > Any ideas? Did you insert the fields using CTRL+F9 for the field boundaries? You cannot simply type curly brackets. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > When using {=({Mergefield fieldname} / 10000)} > [quoted text clipped - 25 lines] >>> I can't figure out a way to tailor my field to meet my criteria. >>> Any ideas? Yes I did. You have to substitute 'fieldname' for the name of your field. It works fine here. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Yes I did. It's an odd situation. It works on the initial letter in the mail merge and calculates fine. As I go through to the rest of the letters in the merge, it tells me !Syntax Error, { I am not sure why it would work on the first one and not the next letters. The error implies that you have an erroneous leading bracket (that's the first error it finds). This suggests that there is a problem with the way you have inserted the fields. All the field combination does is to divide the content of the field by 10,000. In order for this to work, the field must contain a numeric value. I know that you have said that you you inserted the fields using CTRL+F9, but let's try a different tack. Press CTRL+F9 which will give you {} Between the brackets type =( /10000) Immediately after the first round bracket, insert the mergefield from the drop down on the merge toolbar {=(<<fieldname>> / 10000)} Does it work now? If not, check your data file to see what the field actually contains - a simple way to do this is to create a temporary catalog merge containing both the uncalculated field and the calculation on the same line. Merge to a new document. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > It's an odd situation. It works on the initial letter in the mail > merge and calculates fine. As I go through to the rest of the letters [quoted text clipped - 4 lines] > I am not sure why it would work on the first one and not the next > letters. Genius! It worked. Thank you!! |
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.