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.
<ChrisK@discussions.microsoft.com> 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.
> <ChrisK@discussions.microsoft.com> 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
C@discussions.microsoft.com> 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.
>> <ChrisK@discussions.microsoft.com> 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
>> 
>> .
>>