number changes into date-but I do not want it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!!!!!!!!!!!!!!!!
 
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!!!!!!!!!!!!!!!!!!!!
Click to expand...
Right click the cell select format and make sure the cell
isn't formatted as a date field. Should be number.

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