switch off transforming number into date

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

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
 
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
 
Back
Top