This is the way Excel works with a number in a single cell.

Workarounds....................

If you have a 1 in A1 and a 2 in A2, drag/copy will autofill down column A

OR

1 in A1 only.

Right-click and drag. Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Sun, 17 Feb 2008 16:26:20 -0800 (PST), wrote:

Hi There,

numbers, (1,2,3) won't autofill for me in my excel. Everything else
does, like Monday, Tuesday, Wednesday, and 9:00, 10:00 11:00, but if I
type in "1" and autofill, all I get is more one's. Help??