MrExcel Publishing
Your One Stop for Excel Tips & Solutions

change month number into month text


Posted by mabaud on December 29, 2000 2:54 AM


I have a month number (1-12) in one cell and I would like in an other cell to have the coresponding month name (january or february etc.).
I would like to know how to deal with this issue (not only for month, but also for any number that needs to be changed to text)
Thanks for your help.
marcandre

Posted by cpod on December 29, 2000 7:04 AM

There is not function in Excel to convert numbers to text. For your month problem you could use this formula:

=DATE(2000,a1,1)

If your month number is in A1. You then format this as a custom format - "mmmm".

Posted by Aladin Akyurek on December 29, 2000 8:11 AM

Taking up your month-problem.

If it's the case that A1 contains, say 4, meaning the fourth month, and you want the name "April" in B1 & you need doing this often enough,

I would suggest constructing a table on some sheet which looks like:

1 January
2 February
3 March
etc.

Select the cells of this table and name the table MONTHS via the Name Box.

Go now to the cell B1 (adjacent to A1 containing the number 4) and type

=VLOOKUP(a1,MONTHS,2,0)

Aladin

Posted by Dave on January 01, 2001 4:07 AM


Hi marcandre

To expand on the above you could use:

=TEXT(DATE(2000,A1,1),"mmmm")

To covert the number in A1 to a Text month name.


=TEXT(1,"General") will convert the number in A1 to a text number.

Dave

OzGrid Business Applications