G
Guest
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.
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.