| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I stop Excel from changing numbers into a date?
I would like to type in 1-3 but it keeps getting turned into 3-Jan. I have
turned off every option in excel that I can find but it still keeps happening. |
|
#2
|
|||
|
|||
|
Pre-format the cells as text or pre-fix entry with a single apostrophe. (It
will not show but will stop the conversion) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Buckwildbill" wrote in message ... I would like to type in 1-3 but it keeps getting turned into 3-Jan. I have turned off every option in excel that I can find but it still keeps happening. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns in Excel are numbers instead of letters, how do I change . | Excel Discussion (Misc queries) | |||
| BRACKETED NEGATIVE NUMBERS IN EXCEL | New Users to Excel | |||
| In Excel, how to sum top 10 greatest values in a row of numbers? | Excel Worksheet Functions | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
| How do I stop the autopaste function in Excel? | Excel Worksheet Functions | |||
Linear Mode
