number changes into date-but I do not want it

[odabuda]

when I type in the pH value of let's say 11.2 it changes into date like
nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!!

 

[gls858]

when I type in the pH value of let's say 11.2 it changes into date like
nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!!

Right click the cell select format and make sure the cell
isn't formatted as a date field. Should be number.

gls858

 

[Gord Dibben]

Most unusual.

Normal pattern for 11-2 but not 11.2

Try formatting the cells to General.

What is the date separator set for in your Windows>Control Panel>Regional and
Language Options>General>Custom>Date?

Maybe change it from a decimal point to a slash / or -


Gord Dibben Excel MVP