Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of numbers with only two decimal places wrong
I have a spreadsheet 53000 lines long, with a set of numbers in it.
Each number is only two decimals long although previously was longer. I have used both the functions Round and Fixed to two decimal places. I have copied and paste values and tried several different formats. My issue is when I sum these numbers I get a result of 0.000000078768567858 How am I getting this result from numbers that should only be two decimal places? Is there a format or formular that will give me exactly two decimal places so when added it will only give me a result of two decimal places even when I view a large number of decimal places as above. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet defaults numbers automatically to two decimal places | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |