Program Sets > MS Excel

Merging data from spreadsheet to word doc

(1/1)

bahhumbug:
Some of the data I want to merge from the SS is in currency format but it appears in the Word doc without the ? sign (not so important) but also NOT with 2 decimal places. 
 
For instance ?25.00 comes across as 25,
 
?34.50 comes across as 34.5.
 
Am I doing something wrong or is there anything I can do to amend this?

bahhumbug:
There is a way to do this using "field codes"
 
In the word doc Alt + F9
 
that shows the fields to be merged.
 
You then put in how you want it displayed eg
 
# ?####.00

Navigation

[0] Message Index

Go to full version