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?
|