Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
change month number into month textPosted 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.
|Check out our Excel Resources
Re: change month number into month textPosted 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:
If your month number is in A1. You then format this as a custom format - "mmmm".
Re: change month number into month textPosted 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:
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
Re: change month number into month textPosted by Dave on January 01, 2001 4:07 AM
To expand on the above you could use:
To covert the number in A1 to a Text month name.
=TEXT(1,"General") will convert the number in A1 to a text number.
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.