Date options

G

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

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)
 
G

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)




.
Click to expand...
 
Top