Excel formula does not work

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

My spreadsheet is adding 2 two digit numbers and coming up
with 15th digit place answer. It happens throughout the
spreadsheet where ever it wants to.
Does anyone know how to fix this?
I had this problem on 97 sr2, so I upgraded to xp and I
still have the same problem. I have recreated the file
more times than i can count.

Tiffany
 
Your 2 digit numbers are not 2 digits, what happens if you copy one of them,
paste special as values in another cell,
they still are 2 digits? Just because you have formatted for 2 decimal
places it doesn't mean the underlying value is that
You can do this as a one timer, tools>options>calculations and select
precision as displayed, turn that on and off
and they should be 2 digits or round the values either before or after the
sum. Obviously the end result will differ
between before or after the sum..
 
Tiffany

Sounds like a formatting error. Go to FORMAT -> CELLS -> Click on NUMBER and choose how many decimal places you'd like to have

Raz

----- Tiffany wrote: ----

My spreadsheet is adding 2 two digit numbers and coming up
with 15th digit place answer. It happens throughout the
spreadsheet where ever it wants to
Does anyone know how to fix this
I had this problem on 97 sr2, so I upgraded to xp and I
still have the same problem. I have recreated the file
more times than i can count

Tiffan
 
Back
Top