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.

"מיכ�ל (מיקי) �בידן" wrote:

Try to select the whole(!) sheet and then hit: Ctrl+Shift+1
*** The 1 in the upper horizontal numeric keys ***
If this resolves the problem - you may continue formatting your sheet as
General or whatever...
Micky

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


On Wed, 27 Jan 2010 11:32:01 -0800, Chris K.
wrote:

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.

"????? (????) ?????" wrote:

Try to select the whole(!) sheet and then hit: Ctrl+Shift+1
*** The 1 in the upper horizontal numeric keys ***
If this resolves the problem - you may continue formatting your sheet as
General or whatever...
Micky

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" wrote:

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


On Wed, 27 Jan 2010 11:32:01 -0800, Chris K.
wrote:

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.

"????? (????) ?????" wrote:

Try to select the whole(!) sheet and then hit: Ctrl+Shift+1
*** The 1 in the upper horizontal numeric keys ***
If this resolves the problem - you may continue formatting your sheet as
General or whatever...
Micky

.

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
wrote:

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" wrote:

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


On Wed, 27 Jan 2010 11:32:01 -0800, Chris K.
wrote:

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.

"????? (????) ?????" wrote:

Try to select the whole(!) sheet and then hit: Ctrl+Shift+1
*** The 1 in the upper horizontal numeric keys ***
If this resolves the problem - you may continue formatting your sheet as
General or whatever...
Micky

.