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

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

Guest

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?
 
Format the cell(s) as Text first. Then enter 7-13.

Hope this helps
Rowan
 
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
 
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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data auto edit 6
excel won't sort dates correctly 0
Formula for Changing low number of "-" 2
I need a dash, not a formula 2
How do I create a formula to remove dashes? 6
How to STOP Excel from changing my data 1
how do i delete dash in phone numbers 3
Turning off date 4

Back
Top