| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change a date 1/13/2007 to 1/2007
Use custom format m/yy, you cannot convert them since they would no longer
be dates but text but you can change the display -- Regards, Peo Sjoblom "charlie" wrote in message ... I would like to convert a column of dates to be just month and year |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change a date 1/13/2007 to 1/2007
I want to change it not in format but as only being the month and year
without the day "Peo Sjoblom" wrote: Use custom format m/yy, you cannot convert them since they would no longer be dates but text but you can change the display -- Regards, Peo Sjoblom "charlie" wrote in message ... I would like to convert a column of dates to be just month and year |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
| Date Question - 12/1/2007 & "through" & 12/31/2007 | Excel Discussion (Misc queries) | |||
| Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
| Change menu's and toolbars in 2007 | New Users to Excel | |||
| Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) | |||
Hybrid Mode
