| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change a date 1/13/2007 to 1/2007
Select the column of dates, click FORMAT and select CELL. Click the NUMBER
tab if necessary and in the CATEGORY list box, select CUSTOM and in the type field create the following format code: m/yyyy Click OK to format the selected range -- Kevin Backmann "charlie" wrote: I would like to convert a column of dates to be just month and year |
| 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) | |||
Threaded Mode
