Auto date in excell 2010

  • Thread starter Thread starter Chris K.
  • Start date Start date
C

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.
 
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.
 
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
 
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.
 
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
 
Back
Top