Forum Discussion
Fill Series function adding extra decimal data
I needed to fill a column with the numbers 2.30 thru 10.00. I put in 2.30 and 2.31, and then used the Fill Series function by grapping the black square and dragging it down til I got 10.00. Whe...
This is due to the way Excel stores and processes decimal numbers.
If you have a recent version of Excel:
=SEQUENCE(771, , 230)/100
If you have an older version, enter 2.3 in the first cell, say C2.
In C3, enter =ROUND(C2+0.01, 2)
Fill down.