When I type a number into a cell it automatically takes on a date format.
After clearing all formats off the entire column, it continued to do this.
How can I stop it?

You can't really "clear" formats because every cell with an entry has to
have some format, even if text. Try formatting the whole column with some
choice other than date.

"Amy" wrote in message
...
When I type a number into a cell it automatically takes on a date format.
After clearing all formats off the entire column, it continued to do this.
How can I stop it?

I think you don't enter number in cell or cell have a date format yet. to
solve the problem:
1- If you Enter 1/1 or 1-1 you must use ' signe (Single qotation) or
2-Go to format cell, Number page, and select Text

"Amy" wrote:

When I type a number into a cell it automatically takes on a date format.
After clearing all formats off the entire column, it continued to do this.
How can I stop it?