How do I convert “3” to “March”???It’s very simple.Let’s say you have the number 3 in cell A1 and you want March in Cell B1.
Go to cell B1 and type this formula
=TEXT ( DATE(2000,A1,10), “MMM”)
You will get it Mar.How did this work?
The function TEXT works on dates.
So first you will need to create a random date using the 3 as the month number. This is done by DATE(2000,A1,10).
Then you choose the format “MMM” for the output. This gives you Mar (3 letters in the output).You can get different outputs based on the format you want.
If you choose “MMMM”, you will get March (full name of the month).
If you choose “MMMMM”, you will get M (first letter of the month name).Similarly, you can get the name of the day by just changing the format to “DDD”, “DDDD”.
Go to cell B1 and type this formula
=TEXT ( DATE(2000,A1,10), “MMM”)
You will get it Mar.How did this work?
The function TEXT works on dates.
So first you will need to create a random date using the 3 as the month number. This is done by DATE(2000,A1,10).
Then you choose the format “MMM” for the output. This gives you Mar (3 letters in the output).You can get different outputs based on the format you want.
If you choose “MMMM”, you will get March (full name of the month).
If you choose “MMMMM”, you will get M (first letter of the month name).Similarly, you can get the name of the day by just changing the format to “DDD”, “DDDD”.
Not working. My formula is =TEXT(DATE(2000;A1;10);”MMM”) and result is MMM. Not as you said Apr
Hi, there is a small error in the formula you have entered. Instead of ; use , (comma) everywhere.
Hello, your language is not English I guess. Try the “mmmm” part with the first letter of the month in your computer language.
For example, my computer language is Turkish so I’m usign “aaaa” instead of “mmmm”.
Hi, my computer has English Language. If you use “aaaa”, you will get the Day (as Mon, Tue, etc.) instead of the Month name.
Pardon me. I forgat what is A1 cell. A1= 4
I have entered 4 in A1 as an example. 4 means 4th month, which is April.
So if A1 has 9, it would mean September.
Lets say you dont want to have any number but show the current month only in full name.
You can then use this formula i fixed today. The problem is that all is on lowercase.
=TEXT(DATE(2000;(MONTH(TODAY()));1);”MMMM”)
David
Hi David, thank you for your input, it works perfect!
For the lowercase problem, you can simply add an =UPPER in the beginning of your formula
=UPPER(TEXT(DATE(2000,(MONTH(TODAY())),1),”MMMM”))
This will turn your output into Upper Case
Thank you.
Hi, you can start off with Blogger.com since it’s very easy to begin with. Once you get a hang of it, you can move to WordPress. I did the same.