Auto date in excell 2010

[Chris K.]

When I type a number into a cell, Excel automatically creates a date from it,
even if it is just one number like 10 or 4 or 1 or 7. How can I get this to
stop, it is very annoying because I can't enter just a number into the cells
without it turning into a date unless I put a * or some other symbol before
or behind the number.

 

[Chris K.]

Thanks that works, is there a way to turn it off in the settings or not?
Would be nice if there is because then I wouldn't have to do this all the
time.

 

[Gord Dibben]

Does this happen with all worksheets on all workbooks?

New sheets? New Workbooks?

Sounds like all cells are formatted as Date.


Gord Dibben MS Excel MVP

 

[Jessica C]

I am having the same problem. It is happening on all sheets, all workbooks.
I have even reformatted to numbers multiple times, saved, and when I reopen,
they are once again dates.

 

[Gord Dibben]

When you re-format to numbers do they change to that number formatting?

Can you SUM them as numbers?

ALL workbooks and worksheets? Even prior existing workbooks?

Do you have any add-in or Personal.xls with some code that may re-format
active workbooks?

Send me a copy of one of these workbooks by email.

gorddibbATshawDOTca change the obvious.


Gord

On Thu, 28 Jan 2010 07:28:01 -0800, Jessica C <Jessica