switch off transforming number into 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
 
B

Bill Kuunders

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top