View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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