Help with Mail Merge

[spotit3]

I am working on a letter using Mail Merge to incorporate figures from an Excel file. I am having great problems with cash figures which are not even pouunds. e.g. �185.90 keeps coming out as �185.99999999.

I have formatted the cells on the Excel file to currency and 2 decimal places so can't understand what is happening. Any help would be appreciated.

[rojash]

Formatting the cells doesn't change the underlying value, just its appearance within excel. These sorts of error arise in spreadsheets due the rounding errors in the conversion between binary and decimal numbers. You should use the Round() function in the spreadsheet itself to ensure that the underlying values are correct.