Merge Field Ignoring Zeros
I have a merge document in MS Word 2007. The data form is in Excel. When it pulls any financial info over from the excel document it omits any zeros after the decimal point.
So for example, if I have 180.00 and 180.10 in excel it shows up in the merged word document as 180. and 180.1 instead of the correct numbers.
I've tried changing the formatting in Excel to just "text" and it's still missing the zeros in word, so I assume the problem is on the word side.
I'm using this as a merge code "{ MERGEFIELD amount \#,###.##} to try and force it to two digits after the decimal point. "amount" is the name of the field in excel.
Is there a better merge code I could be using that would show the correct figure with the zeros in?
Many thanks in advance.
|