| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates in Excel
Why does Excel assume that when you type December 2004 that you want
the numeric equivalent and not a text entry? Is this just another illustration of Microsoft knowing what we need before we know it? Thanks |
|
#2
|
|||
|
|||
|
I don't know why MS assumes this but you can precede the entry with an
apostrophe and it will be text -- Regards, Peo Sjoblom "FJB" wrote in message oups.com... Why does Excel assume that when you type December 2004 that you want the numeric equivalent and not a text entry? Is this just another illustration of Microsoft knowing what we need before we know it? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
| In Excel spreadsheeet the dates change to the wrong date after we. | Excel Discussion (Misc queries) | |||
| dates in Excel 2003 | Excel Discussion (Misc queries) | |||
| how do I show dates in a column in an excel worksheet? | Excel Discussion (Misc queries) | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Linear Mode
