Format the number using the Custom option. Under Type key in m/yyyy

"Newbee" wrote:

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.