Date formatting in Excel

R

Ricky4

In Excel, how do I get my date to read like this: June 2008. I do not seem
to have this format available in the date formatting window for Excel. Can I
create a new date format?
 
B

BoniM

choose custom under Number category and enter:
mmmm yyyy
it will display any date with full month name and year, no day.
This does not changed what is stored in the cell, it will still be the
actual date when used in sorts or formulas....
 
B

Bob Phillips

Create a custom format of mmmm yyyy

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top