thanks Faraz, but putting a space may constitute a problem with the
alignment issue, specially if you have a spreadsheet with lots of rows. But
thanks for your reply anyway.



"FARAZ QURESHI" wrote:

How about simply adding a space before 2-3

"Fady" wrote:

Hello,

I would like to know guys how to stop excel from automatically converting my
numbers into dates. I type "2-3" in a cell, and whenever I hit enter or next,
I found it changed to 2-3 February. How can I stop that?

Thanks for yoru help