Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel calculating a number?
Why is there a number being calculated when I am subtracting the same
amounts? I have a sum in one cell and a number in another - which are essentially the same amount but Excel is showing a decimal number like ..0000000021. Also, I am formating the cell as number with two decimals - the default, I believe, when the comma "," icon is selected in the toolbar. Also, the number shows 0, but when I extend the decimal places I see that it is the number above. Also, I have a similar situation in another record but it shows the "-" symbol for zero. -- Gator |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel for calculating stock cover based on a number of months sale | Excel Worksheet Functions | |||
Calculating Time with a number value | Excel Worksheet Functions | |||
Calculating number of people | Excel Discussion (Misc queries) | |||
Text number to number value for calculating | Excel Worksheet Functions | |||
Calculating number of days | Excel Worksheet Functions |