Date options

[Guest]

I have been trying to enter the date as June 2004, but
Excel will not allow this simple option? I've tried
other options, but the closest I can find is June-04.
None of their other options is what I want. I simply
want June 2004. How can I enter this without it
automatically defaulting to something else?
Thank you.

 

[Bob Phillips]

Add a custom format of "mmmm yyyy" without the quotes

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Thank you, that worked!

-----Original Message-----
Add a custom format of "mmmm yyyy" without the quotes

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.