Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
How to convert the month in number to the month in text ?
For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
=TEXT(DATE(YEAR(TODAY()),A1,1),"mmmm yyyy")
If this post helps click Yes --------------- Jacob Skaria "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
This works with regional date settings of U.S. English:
=TEXT(A1&"-1","mmmm yyyy") -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... =TEXT(DATE(YEAR(TODAY()),A1,1),"mmmm yyyy") If this post helps click Yes --------------- Jacob Skaria "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
This works with regional date settings of U.S. English:
=TEXT(A1&"-1","mmmm yyyy") If you use regional date settings of the format: d/m/y then it would stand to reason that reversing the cell ref and the 1 should work: =TEXT("1-"&A1,"mmmm yyyy") -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... This works with regional date settings of U.S. English: =TEXT(A1&"-1","mmmm yyyy") -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... =TEXT(DATE(YEAR(TODAY()),A1,1),"mmmm yyyy") If this post helps click Yes --------------- Jacob Skaria "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
Well Check out this formula......
I belive, it should be sufficient...... First custmosize the B1 to format(custom) in that have it as mmmm yyyy Then put the formula in B1 as =Date(2009,A1+1,0) Well it will return as Feburary 2009, Now I hope that is helpful and simple.... And if you ask me why I have taken "A1+1" the i am not aware but it works that way..... "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
Hi, K****ij & Valki,
Thanks for your formula. Pls be kind to explain how the Date & Text worked in this formula. Thanks, "K****ij" wrote: Well Check out this formula...... I belive, it should be sufficient...... First custmosize the B1 to format(custom) in that have it as mmmm yyyy Then put the formula in B1 as =Date(2009,A1+1,0) Well it will return as Feburary 2009, Now I hope that is helpful and simple.... And if you ask me why I have taken "A1+1" the i am not aware but it works that way..... "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
Well in may case it was simple that i had formated the cell to just show the
month and Year..... Remember we had done-- right click on cell... Format and then Number and Custom...... and TYpe..... "MMMM YYYY", this mad it to text, and the Date formula is the regular date formula..... nothing else..... So chill..... If you found the answer useful, Please press yes at bottom.... Ok.... "yclhk" wrote: Hi, K****ij & Valki, Thanks for your formula. Pls be kind to explain how the Date & Text worked in this formula. Thanks, "K****ij" wrote: Well Check out this formula...... I belive, it should be sufficient...... First custmosize the B1 to format(custom) in that have it as mmmm yyyy Then put the formula in B1 as =Date(2009,A1+1,0) Well it will return as Feburary 2009, Now I hope that is helpful and simple.... And if you ask me why I have taken "A1+1" the i am not aware but it works that way..... "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
Hi, K****ij,
Actually, i wish to know how does the Date & Text function work in the formula ? Why "A1+1" in your formulae and "1-"&A1 in Valko formulae ? Thanks, "K****ij" wrote: Well in may case it was simple that i had formated the cell to just show the month and Year..... Remember we had done-- right click on cell... Format and then Number and Custom...... and TYpe..... "MMMM YYYY", this mad it to text, and the Date formula is the regular date formula..... nothing else..... So chill..... If you found the answer useful, Please press yes at bottom.... Ok.... "yclhk" wrote: Hi, K****ij & Valki, Thanks for your formula. Pls be kind to explain how the Date & Text worked in this formula. Thanks, "K****ij" wrote: Well Check out this formula...... I belive, it should be sufficient...... First custmosize the B1 to format(custom) in that have it as mmmm yyyy Then put the formula in B1 as =Date(2009,A1+1,0) Well it will return as Feburary 2009, Now I hope that is helpful and simple.... And if you ask me why I have taken "A1+1" the i am not aware but it works that way..... "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Month Display
=TEXT(A1&"-1","mmmm yyyy")
=TEXT("1-"&A1,"mmmm yyyy") Depending on your regional date settings Excel will interpret an entry like 1-2 or 2-1 as a valid date of the current year. For examle, with my regional date settings as U.S. English, if I type in cell A1 2-1 Excel automatically evaaluates that as a date and displays 1-Feb. Basically, in the formula we're just taking advantage of Excel's eagerness to identify dates! -- Biff Microsoft Excel MVP "yclhk" wrote in message ... Hi, K****ij, Actually, i wish to know how does the Date & Text function work in the formula ? Why "A1+1" in your formulae and "1-"&A1 in Valko formulae ? Thanks, "K****ij" wrote: Well in may case it was simple that i had formated the cell to just show the month and Year..... Remember we had done-- right click on cell... Format and then Number and Custom...... and TYpe..... "MMMM YYYY", this mad it to text, and the Date formula is the regular date formula..... nothing else..... So chill..... If you found the answer useful, Please press yes at bottom.... Ok.... "yclhk" wrote: Hi, K****ij & Valki, Thanks for your formula. Pls be kind to explain how the Date & Text worked in this formula. Thanks, "K****ij" wrote: Well Check out this formula...... I belive, it should be sufficient...... First custmosize the B1 to format(custom) in that have it as mmmm yyyy Then put the formula in B1 as =Date(2009,A1+1,0) Well it will return as Feburary 2009, Now I hope that is helpful and simple.... And if you ask me why I have taken "A1+1" the i am not aware but it works that way..... "yclhk" wrote: How to convert the month in number to the month in text ? For example : in cell A1 enter 2 in cell B1 display February 2009 Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display month only | Excel Discussion (Misc queries) | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) |