Hi all, thanks in advance for any help... we use an Excel workbook to store information about small loans, and calculate a monthly payment by dividing the total due by the number of months. However, when we print the merged info sheet from Word, it expands that dollar amount to 12 decimal places, even though the cells are formatted as 2 and we use the ROUND function in the formula itself to limit to 2 places. Any ideas how to force Word to truncate back to 2 places? Thanks!
Hello Devillocks, welcome to the forum.
You can use a format switch in your merge field
{Mergefield MyNumber \# #.###.00 }
cheers,
Bit late but FWIW I tend to use this approach which pulls the formatting through from the Excel file and saves time.
http://wordprocessing.about.com/od/u...t/exceldde.htm
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thanks heaps~! Those codes did the trick. I'm using 2007 here, so I couldn't find the equivalent to the Tools menu for your option Domski, but that's a neat trick that I can use at home. Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks