Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month function
In using the month function I have encountered the following problem with
formatting. If I format the cells general or mm, I get the corresponding digit to reflect the correct month. However, If I use "mmm" or "mmmm", I get Jan or January no matter what month. How can I format this column using mmm or mmmm and get the correct result? I am using Office 2003. I would like to have the month spelled out instead of just the digit(s) that reflect the month. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month function
I assume you have a month numeric in a cell which you are trying to display
as month text. Try =DATEVALUE("2009-" & A1 & "-1") (and format it to "mmm") If this post helps click Yes --------------- Jacob Skaria "ispy1009" wrote: In using the month function I have encountered the following problem with formatting. If I format the cells general or mm, I get the corresponding digit to reflect the correct month. However, If I use "mmm" or "mmmm", I get Jan or January no matter what month. How can I format this column using mmm or mmmm and get the correct result? I am using Office 2003. I would like to have the month spelled out instead of just the digit(s) that reflect the month. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month function
If a cell has a date in it, then mm will display the month number and mmm
will display the month as text. If a cell has a simple number like 1, 2, 3,......., then the formula: =DATE(2009,A1,1) will also display the month as text if formatted as mmm. -- Gary''s Student - gsnu200859 "ispy1009" wrote: In using the month function I have encountered the following problem with formatting. If I format the cells general or mm, I get the corresponding digit to reflect the correct month. However, If I use "mmm" or "mmmm", I get Jan or January no matter what month. How can I format this column using mmm or mmmm and get the correct result? I am using Office 2003. I would like to have the month spelled out instead of just the digit(s) that reflect the month. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month function
The MONTH function returns a number from 1 to 12 (see Excel help for the
MONTH function). If you format a cell containing a number from 1 to 12 as mmm or mmmm it will, of course, show as January, as the dates represented by numbers 1 to 12 are 1 Jan 1900 to 12 Jan 1900. If you want to format as mmm or mmmm, do that to the date you started with, not to the output of the MONTH function. -- David Biddulph "ispy1009" wrote in message ... In using the month function I have encountered the following problem with formatting. If I format the cells general or mm, I get the corresponding digit to reflect the correct month. However, If I use "mmm" or "mmmm", I get Jan or January no matter what month. How can I format this column using mmm or mmmm and get the correct result? I am using Office 2003. I would like to have the month spelled out instead of just the digit(s) that reflect the month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
=Month function in Excel gives incorrect month | New Users to Excel |