Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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

Check out our Excel Resources

Re: change month number into month text

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".


Re: change month number into month text

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


Re: change month number into month text

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.