How do I disable Excel from changing numbers with dashes to dates?

I

iRox

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

Rowan Drummond

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

Hope this helps
Rowan
 
R

Rowan Drummond

Delete any value (date) that you already have in the cell. With the cell
selected, from the menus select Format>Cells. Select the Number tab. On
the left had side you will see a box with a number of options, click on
Text. Click OK.

Now you should be able to type 7 - 13 in the cell.

Regards
Rowan
 
I

iRox

THANK YOU!!!

-iRox


Rowan Drummond said:
Delete any value (date) that you already have in the cell. With the cell
selected, from the menus select Format>Cells. Select the Number tab. On
the left had side you will see a box with a number of options, click on
Text. Click OK.

Now you should be able to type 7 - 13 in the cell.

Regards
Rowan
Click to expand...
 
R

Roger Govier

Hi

As an alternative to Rowan's suggestion about pre-formatting the cells as
Text, you can precede the entry with a single quote '7 - 13.
The quote won't show up in the cell, only in the formula bar, but it will
make the cell value a text value.

Regards

Roger Govier
 
Top