| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
