| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Stop numbers converting to dates.
How do I stop a number from being converted to a date? Example: When I
enter the number 02-08 it automatically converts to "Feb-8". I have tried formating the cell as a number, but the date conversion overrides the formating and makes it a date. I have tried entering the number as text, but then have trouble sorting. I realize that enter a digits from 1 thru 12 with a hyphen causes the date conversion. How do I TURN IT OFF? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop rounding numbers? | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| roundoff when converting text to numbers | Excel Worksheet Functions | |||
| converting dates into numbers | Excel Discussion (Misc queries) | |||
| micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
Threaded Mode
