A1 is hard-coded 12/15/2012 and I want B1 to = A1 but return the date in the format of month and year only, like December, 2012. Thoughts?
A1 is hard-coded 12/15/2012 and I want B1 to = A1 but return the date in the format of month and year only, like December, 2012. Thoughts?
by formula:
=text(a1,"MMMM, YYYY")
by cell format:
Right click on B1, format cell, Number Tab, Custom, Type MMMM, YYYY in the input Type field
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
by formula:
=text(a1,"MMMM, YYYY")
by cell format:
Right click on B1, format cell, Number Tab, Custom, Type MMMM, YYYY in the input Type field
Love this site... thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks