 |
 | 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 / February 2006Lining up by the decimal point in a table of merged fields
We are trying to create a table which has mutliple conditions set in (incl suppression), but the end results we want to line up by the decimal points. For example: $X,XXX.XX $X,XXX $XX,XXX $XX,XXX.XX Sometimes the merge fields will contain the cents, but most of the time it will just be an even dollar amount, and no, we cannot put in $X,XXX.00. The client refuses. Any suggestions? Thanks! Michele Format your merge fields with decimal tabs. :) i.e., on a right-aligned paragraph: <tabcharacter> <mergefield> You'll want to format your merge fields to all show decimals, I assume: http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com > We are trying to create a table which has mutliple conditions set in (incl > suppression), but the end results we want to line up by the decimal [quoted text clipped - 12 lines] > Thanks! > Michele Sounds great, but I don't know what a decimal tab is. Can you help me out with how we would go about setting up one? And is it possible in a table? Everything is listed in a 3-column, 1-row table. So in the end it's supposed to look like this: 2005 Salary: $135,000 Bonus Opportunity: $40,500.50 2006 Salary: $148,500 Total Compensation: $189,000.50 Thanks! Michele > Format your merge fields with decimal tabs. > :) [quoted text clipped - 24 lines] > > Thanks! > > Michele Yep. Even easier in a table. In front of the $135,000... put a tab (Ctrl+tab to insert a tab inside a table). Select all the cells like that one. Right-align the paragraph (just click right-align). Make sure you check out the article on editing your form fields so that you get $135,000.00 instead of $135,000. I made you a sample file here: http://www.officearticles.com/downloads/decimalalignmerge.zip ************ Hope it helps! Anne Troy www.OfficeArticles.com > Sounds great, but I don't know what a decimal tab is. Can you help me out > with how we would go about setting up one? And is it possible in a table? [quoted text clipped - 40 lines] >> > Thanks! >> > Michele |
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.