Excel Query

[spotit3]

Hi, I am doing a mail merge letter using info from an Excel sheet. I am having a problem with the currency column. I have formatted the cells as currency, 2 decimal places. This seems to work fine where the figures are even pounds or fifty pence.
The problem arises with the occasional odd figure. e.g. if the figure in a cell is £2.37 when this is merged into my letter it comes out as £2.000000037. (The amount of noughts may not be correct as I don't have it in front of me at the moment but you get the idea.) This happens with all odd figures.

Any help would be greatlyappreciated.

[Sonyme]

Format the cells as Number with 2 dec. places

[spotit3]

Still doesn't work once you complete the mail merge, Sonyme. The 6.37 came out as 6.0000000000000371. I have tried formatting the cells as numbers and has currency but they both come out like this. It is doing my head in so if anyone can help, please do.

[spotit3]

I have almost got there. I have discovered if I format the cells as Accounting with 2 decimal places it will work. I am now trying to working out how to keep it from shortening anything ending in a nought to one decimal place. e.g. .50 becomes .5

[scotman]

Is the sum of money in each cell an input figure or the result of a calculation? Which versions of the software are you using?

[spotit3]

The cell contents are input figures and I am using Office 2003.

[Sonyme]

If the cells in Excel contain input data and they perform no arithmetical function in the mail merge documents ( other than to indicate a value) then make the excel cells "TEXT" cells.The data should then transfer exactly. You will of course have to input any trailing zero. I am not familiar with Office but I think you strike " before your figures.

[spotit3]

Thanks Sonyme, that solves half of the problem but I don't understand what you mean by inputting any trailing zero. Does this mean I would have to do this on each of the 500 or so? it wouldn't really be realistic.

[spotit3]

The problem seems to be when I to merge it into a Word document. It appears OK in the Excel document but immediately it is merged wirh Word it does it's own thing!!

[spotit3]

Eureka!! At long last I have solved it by using Dynamic Data Exchange (DDE).
Thanks everyone for your reples.