Convert Date format

N

Newbee

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.
 
S

Shane Devenshire

Hi,

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

Cheers,
Shane Devenshire
Microsoft Excel MVP
 
P

Peo Sjoblom

If you format as m/yyyy what do you get?
Note that formatting has nothing to do with underlying values.

If you group the dates using month and year you will get the chart showing
per month as well


--


Regards,


Peo Sjoblom
 
N

Newbee

I tried that but when I pivot table the information. It is not a date
anymore it seems to be text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
VBA - exporting serial letters to single documents 0
Date Formats 4
Excel PRICE function: How does it compute Issue Date of the Security 5
How can the font and size of (all) citation numbers be altered? 1
Checking for date and time overlaps 0
Formula convert date to month format 7
Dealing with a Pivot Table (when I don't want to) 0

Top