| 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 | |||
Threaded Mode
