Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Shows 0.00 but still has a number
I have a formula in a cell that calculates a range of cells. The cell that
contains the formula shows 0.00 after it factors in all of the numbers. The problem is that the number in the cell is not really 0.00. If you expand the number of decimal places to 12 it will show as 0.000000365214. This shows even if you manually calculate all of the numbers and the answer is 0.00. I have tried to copy the formula from another cell where this does not occure but end up with the same results. I am trying to do a conditional format that highlight cells that equal 0.00. With this happening the formatting is not working because the answer is not 0.00. Any help to correct this would be great. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Shows 0.00 but still has a number
Round the result:
=Round(formula,2) "Rob" wrote: I have a formula in a cell that calculates a range of cells. The cell that contains the formula shows 0.00 after it factors in all of the numbers. The problem is that the number in the cell is not really 0.00. If you expand the number of decimal places to 12 it will show as 0.000000365214. This shows even if you manually calculate all of the numbers and the answer is 0.00. I have tried to copy the formula from another cell where this does not occure but end up with the same results. I am trying to do a conditional format that highlight cells that equal 0.00. With this happening the formatting is not working because the answer is not 0.00. Any help to correct this would be great. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Shows 0.00 but still has a number
more info here
http://www.cpearson.com/Excel/rounding.htm "Rob" wrote: I have a formula in a cell that calculates a range of cells. The cell that contains the formula shows 0.00 after it factors in all of the numbers. The problem is that the number in the cell is not really 0.00. If you expand the number of decimal places to 12 it will show as 0.000000365214. This shows even if you manually calculate all of the numbers and the answer is 0.00. I have tried to copy the formula from another cell where this does not occure but end up with the same results. I am trying to do a conditional format that highlight cells that equal 0.00. With this happening the formatting is not working because the answer is not 0.00. Any help to correct this would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My number shows as text | Excel Worksheet Functions | |||
Number 6 shows as s | Excel Discussion (Misc queries) | |||
page number shows in background | Excel Discussion (Misc queries) | |||
cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
Why does the formula result show a number but the screen shows ze. | Excel Worksheet Functions |