Mail Merge

[traff1982]

Hi,

I have merged data from an excel spreadsheet to a word document but when the figures are put into the document they are not quite correct.
E.g. the figure in Excel is 1100.92 but when merged the figure will be 1100.9200000001. I have checked the spreadsheet and have used the =Round and =Roundup function but this does not seem to help.

Any ideas on what is happening would be appreciated.

Cheers

Marc

 

[Marbles]

If you Right Click in the field in the document, before merging. Then choose Toggle Field Codes, try adding this: \###.00 just after your field name.

{MERGEFIELD "YourField"\###.00 }

 

[Macropod]

Hi traff1982,

While

{MERGEFIELD "YourField"\###.00 }

will work, you'll get an extra empty space before any value that only has a single digit before the decimal point, and two blanks instead of a leading 0 for values less than 1. If you use

{MERGEFIELD "YourField"\# ,0.00 }

, you'll get as many digits as needed before the decimal point, including leading 0s for values less than 1, and a thousands separator for values of 1,000 or more.

Cheers

 

[traff1982]

cheers for the help