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.
When I investigate the cells, they have the number expect.
For a while.
Suddenly I start getting extra decimal data.
The first one occurs at 2.54
And it just grows.
As you can see I don't have any added formatting. It defaults to General.
Where is this extra decimal data coming from?
I even tried using a formula where my first cell is 2.3 and my next cell is the previous cell + 0.01. Fill Series down til 10.00. I then take those cells and copy the value. Same extra decimal data.
BUT...
For kicks I tried it with 0, 0.1, and 0.2 and did the Series Fill. That's clean all the way to 10.
1 Reply
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.
