I have read and tried clicking on "set precision as display" and also tried formating the cell to all different things including moving the decimal point and have had no luck what so ever and its driving me crazy ! I have resorted in doing the calculation on a calculator and then added the amount as text.