Mail Merge from and Excel Database

[Matt]

When I complete a mail merge from an excel database in
word, I open the merged documents. As the database
contains $ values with decimal places, I need the letters
to show 2 decimal places. This is fine when there is a
whole figure at the end of the information, however when
it is something like $35.30, everything will show up
except the 0 at the end. Can I overcome this?

 

[Greg Maxey]

Matt,

Try a numerical switch in your mergefield

{ your mergefield \# "$,#.00;($,#.00)" }