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
|