View Single Post
  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default How do I disable Excel from changing numbers with dashes to dates?

Format the cell(s) as Text first. Then enter 7-13.

Hope this helps
Rowan

iRox wrote:
I want to enter "7 - 13" but Excel changes it to "13 Jul 2005" I have tried
turning off AutoCorrect but that doesn't work. Does anyone know how to turn
this automatic change off?