Sounds like the value in the cell is text not a number.

Create a new blank sheet. Type 1 into a blank cell.
Hold down Ctrl and when the bottom right of the cell turns to a black cross drag it down. The numbers should increase by one.

Now use the same process on your data.
If it copies the same cell then the value is text.