View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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