switch off transforming number into date
 

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

switch off transforming number into date
 

These cells may have been formatted as a date in a previous set up.
One way to avoid this is to format all as numbers or general.
General format will still convert for instance 12/10/23 as a date
but it should keep 12.42 as a number.

Greetings from New Zealand

"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

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