excel calculations

J

jose.borja

Working with Excel 2002 (10.2614.2625), I format 3 cells
as numeric w/o decimals and comma separated, then input
111,111,111 in one cell, then copy that to the second
cell, finally multiply those two cells, the result that
shows in the third cell is 12,345,678,987,654,300. But if
I do that operation with the calculator, the result I get
is 12,345,678,987,654,321... why is that ?!?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top