Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I disable Excel from changing numbers with dashes to dates?
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
How do I disable Excel from changing numbers with dashes to da
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? |
#4
|
|||
|
|||
How do I disable Excel from changing numbers with dashes to da
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
How do I disable Excel from changing numbers with dashes to da
You're welcome!
iRox wrote: THANK YOU!!! -iRox |
#7
|
|||
|
|||
How do I disable Excel from changing numbers with dashes to dates?
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 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions |