View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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