How do I disable Excel from changing numbers with dashes to da
THANK YOU!!!
-iRox
"Rowan Drummond" wrote:
Delete any value (date) that you already have in the cell. With the cell
selected, from the menus select FormatCells. 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
iRox wrote:
Um... How do you do that? Sorry I'm kinda new to Excel...
-iRox
"Rowan Drummond" wrote:
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?
|