| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel date obstruction!
I have a column in which I want to type dates like
December 2004 June 2003 etc IOW, no fancy formatting. But how in darnation do I do it please? It seems I cannot use 'General' for a date, or my entries are turned into a serial number like 37956. After using custom and entering 'mmmm yyyy', I seemed to make progress. But now I cannot *edit* such an entry. Excel insists on showing 'December 2003' in the edit box as '01/12/2003'. -- Terry, West Sussex, UK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) | |||
| In Excel, I need a date math formula... | Excel Discussion (Misc queries) | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Threaded Mode
