How do I stop auto conversion of numbers to a date?
 

I type in 9-5 and Excel automatically changes my entry to 9-May. I've tried
to stop it using Autoformat but it hasn't worked.

How do I stop auto conversion of numbers to a date?
 

Format the cell as Text before entering any information into it.
--
Gary''s Student - gsnu200756


"L" wrote:

I type in 9-5 and Excel automatically changes my entry to 9-May. I've tried
to stop it using Autoformat but it hasn't worked.

How do I stop auto conversion of numbers to a date?
 

L

Preceed your entry with an apostrophe or formate the cells as text.

Mike Rogers

"L" wrote:

I type in 9-5 and Excel automatically changes my entry to 9-May. I've tried
to stop it using Autoformat but it hasn't worked.