ChatterBank1 min ago
Excel Query
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.
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.
Answers
Best Answer
No best answer has yet been selected by spotit3. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.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.