View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JButler JButler is offline
external usenet poster
 
Posts: 1
Default 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.