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
|