Hi,

Choose Format, Cells, Number tab, Custom and on the Type line enter M/YYYY

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Newbee" wrote in message
...
I have a date 1/25/2008 and I want to format to 1/2008 with the format
still
being a date not text so that it will pivot on a chart with that info.