While writing a column of numbers, some numbers suddenly change to dates. I
erase the date, rewrite the numbers and, again, pressing enter it changes
back to a date. Does not do it each time, but several numbers in the column
will have dates. I am a new excel user so what am I doing wrong?

If you enter the same value into two cells and one cell displays the value
and the other cell displays a date, then the problem is formatting.

Empty the cells, format the cells as general and then re-enter the values
--
Gary''s Student


"molly d" wrote:

While writing a column of numbers, some numbers suddenly change to dates. I
erase the date, rewrite the numbers and, again, pressing enter it changes
back to a date. Does not do it each time, but several numbers in the column
will have dates. I am a new excel user so what am I doing wrong?

Thanks you. I worked.

"Gary''s Student" wrote:

If you enter the same value into two cells and one cell displays the value
and the other cell displays a date, then the problem is formatting.

Empty the cells, format the cells as general and then re-enter the values
--
Gary''s Student


"molly d" wrote:

While writing a column of numbers, some numbers suddenly change to dates. I
erase the date, rewrite the numbers and, again, pressing enter it changes
back to a date. Does not do it each time, but several numbers in the column
will have dates. I am a new excel user so what am I doing wrong?