Excel Auto-Convert my text to date

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

Guest

Hi!,
When I enter a text (in this format 1-10) excel convert this to 1 Jan. Is there a way that I can prevent excel to auto-convert my text format(e.g 1-10) to date format (1 Jan) ?

Thanks a lot
Mpho
 
Back
Top