| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How does one disable Auto-Formatting of dates?
Whenever I type something like 2-3 it automatically gets changed to a date
(i.e. 3 Feb.) I've tried changed the cell properties to "general" but that only covert the date to the Excel day number (c. 38 000). When I delete it and start over the autoformat is on again. How do I stop this? I just want the computer to display two numbers with a dash in between. Is that too much to ask? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How does one disable Auto-Formatting of dates?
Pre-format the cell as text or start your entry with an apostrophe: '2-3
Clarissimus wrote: Whenever I type something like 2-3 it automatically gets changed to a date (i.e. 3 Feb.) I've tried changed the cell properties to "general" but that only covert the date to the Excel day number (c. 38 000). When I delete it and start over the autoformat is on again. How do I stop this? I just want the computer to display two numbers with a dash in between. Is that too much to ask? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use conditional formatting to hilite weekend dates where. | Excel Worksheet Functions | |||
| Disable auto-formatting dates.... GRRR! | Excel Discussion (Misc queries) | |||
| Auto formatting | Excel Discussion (Misc queries) | |||
| conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
| Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
Linear Mode
