| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel is turning entered dates into formulas despite format. Why?
I have a worksheet that turns all numbers with an operator into a formula.
For instance when I enter "4/11/06" it changes it to "=4/11/06". This is regardless of what the cell format is, date, general, etc. I can create another worksheet in this workbook and this does not occur. I can get around this problem, but there is something tied to this particular sheet that changes what is entered and I would like to find it. Any help out there? This is Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel is turning entered dates into formulas despite format. Why?
Toolsoptionstransition uncheck transition formula entry, it is for
compatibility with Lotus 123 -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Matt Mahan" <Matt wrote in message ... I have a worksheet that turns all numbers with an operator into a formula. For instance when I enter "4/11/06" it changes it to "=4/11/06". This is regardless of what the cell format is, date, general, etc. I can create another worksheet in this workbook and this does not occur. I can get around this problem, but there is something tied to this particular sheet that changes what is entered and I would like to find it. Any help out there? This is Excel 2003 |
|
#3
|
|||
|
|||
|
You, sir, are a genius! I registered with this site just to thank you for defanging this beast that's been driving me absolutely mad!
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| How do I sort dates in Excel | Excel Discussion (Misc queries) | |||
| How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
| access dates in excel, how to change format? | Excel Discussion (Misc queries) | |||
| Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
Linear Mode
