Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
switch off transforming number into date
"aa" wrote in message ... How do I switch off that autocomplete or autoformat or whatever the name of that feature, which transform a decimal number like 12.42 into marcian-looking date like Dec.42 ? It does it at random in some cells You might also look at "Transitional formula entry" in the customization settings. mike ====================== in my Options--Transitions-- the box Transition formula evaluation is not ticked |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
switch off transforming number into date | Excel Discussion (Misc queries) | |||
SWITCH NUMBER BY LETTERS | Excel Discussion (Misc queries) | |||
switch number order | Excel Worksheet Functions | |||
Transforming Table into Matrix | Excel Discussion (Misc queries) | |||
Transforming Data | Links and Linking in Excel |