If I have the number in a cell, how do i create a formula that will turn that into March? Or if I have a date 3/12/13, how can I have a formula that will make that March, but the text, not the date.
If I have the number in a cell, how do i create a formula that will turn that into March? Or if I have a date 3/12/13, how can I have a formula that will make that March, but the text, not the date.
You can change the number format to "mmmm"
or use this formula :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
With the 3 in A1, March will be returned.
Formula:Please Login or Register to view this content.
With the date in A3, this will extract the month in long format.
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
@ GC Excel. The number formatting thing doesn't work.
@newdover. That worked. Thanks.
Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks