I have copied a number from another worsheet onto a cell (G-5) on another
spreadsheet then typed a formula into a cell B5=G5/210 but the answer differs
from that as when i work it out on a calculator. I think the reason is the
decimal places that i have brought in from the other worksheet, but if i
check the number of decimal places, it is already set at 2 decimal places.
This is giving us a nightmare on an accounting system that we have which
differs in the final answer to the spreadsheet that we have.
Can anybody help me?