automatic = sign
 

I have a worksheet that automatically places an = sign before numbers. For
example, if I enter "12/1/2006" to the date, excel changes this to
"=12/1/2006", does the division and I get a number that is very small and
when formated as a date appears as 1/1/1900. I know how dates work and why
this is happening, so what I want to know is how to make excel stop entering
the = sign. This only happens on one particular workbook and all other
workbooks are not affected.

automatic = sign
 

ToolsOptionsTransition.

Uncheck all the Transition checkboxes.

Those are for ex-Lotus users and have no function in Excel except to make life
miserable by creating problems as you describe.


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 11:02:11 -0700, JButler
wrote:

I have a worksheet that automatically places an = sign before numbers. For
example, if I enter "12/1/2006" to the date, excel changes this to
"=12/1/2006", does the division and I get a number that is very small and
when formated as a date appears as 1/1/1900. I know how dates work and why
this is happening, so what I want to know is how to make excel stop entering
the = sign. This only happens on one particular workbook and all other
workbooks are not affected.