| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| 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 | |||
Linear Mode
