What you describe seems to be right and the formula is almost right - I had assumed that the number was in A1, but you now say that it is in D18. So, type the formula in E18 and change the A1 to D18. You can then copy it down to E22 to convert any numbers that are in D19:D22.
Hope this helps.
Pete
Bookmarks