Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel: How do I turn off automatic e-mail if text has @ sign? | Excel Discussion (Misc queries) | |||
How do I get an automatic equal sign to begin the formula bar? | New Users to Excel | |||
can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
-ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions |