LinkBack URL
About LinkBacks
I want to write dates as only month and year, e.g. May 2012 or June 2012.
Is this possible?
I dont want the day at all
Any help would be gratefully received
Mary
I want to write dates as only month and year, e.g. May 2012 or June 2012.
Is this possible?
I dont want the day at all
Any help would be gratefully received
Mary
hi Mary F, welcome to the forum. you can type it as 1 May 2012, but show it as May 2012 by going right-clicking -> Format Cells -> Custom Format:
mmm yyy
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Mnat thanks. It works
I have been using Excel for years at work and play and never looked at custom. I wish I had known this 30 years ago
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks