Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't Stop Date Values from Changing to Formulas
I have a very old spreadsheet,which appears to have been converted from Lotus
at some point, which will not allow me to type a date in a cell without it automatically converting it to a formula after I hit ENTER. This obviously results in a value which I don't want to see. I can't seem to delete the equal sign from any of the cells with dates in them. I delete it, hit ENTER, then it appears again. It only happens on the one sheet in question and appears to be related to how it was converted from Lotus. Any ideas how to turn off this property? I validated that the sheet is saved in Microsoft Excel format. Willy V |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't Stop Date Values from Changing to Formulas
On Mon, 23 Jul 2007 14:48:03 -0700, WillyV
wrote: I have a very old spreadsheet,which appears to have been converted from Lotus at some point, which will not allow me to type a date in a cell without it automatically converting it to a formula after I hit ENTER. This obviously results in a value which I don't want to see. I can't seem to delete the equal sign from any of the cells with dates in them. I delete it, hit ENTER, then it appears again. It only happens on the one sheet in question and appears to be related to how it was converted from Lotus. Any ideas how to turn off this property? I validated that the sheet is saved in Microsoft Excel format. Willy V Tools/Options/Transition Deselect the Sheet Options (I can't recall if it is transition formula entry or evaluation). --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't Stop Date Values from Changing to Formulas
ToolsOptionsTransition.
Uncheck the Lotus Transition checkboxes. Gord Dibben MS Excel MVP On Mon, 23 Jul 2007 14:48:03 -0700, WillyV wrote: I have a very old spreadsheet,which appears to have been converted from Lotus at some point, which will not allow me to type a date in a cell without it automatically converting it to a formula after I hit ENTER. This obviously results in a value which I don't want to see. I can't seem to delete the equal sign from any of the cells with dates in them. I delete it, hit ENTER, then it appears again. It only happens on the one sheet in question and appears to be related to how it was converted from Lotus. Any ideas how to turn off this property? I validated that the sheet is saved in Microsoft Excel format. Willy V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to Stop =TODAY() date function changing byitself | Excel Worksheet Functions | |||
How to stop text changing to date | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
stop changing data to date | New Users to Excel |