| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display month name instead of number
I'm trying to display the month name abbreviation mmm instead of number. My
date is in cell C5 in the formula examples below. If I use =TEXT(MONTH(C5),"mmm") I always get Jan no matter what the actual date (ie 7/30/84 or 1/27/84) If I use =TEXT(DATE(1900,C5,1),"mmm") I get a month name but not the right one. For example Actual Date Formula results 7/30/84 May 1/27/84 Dec 8/1/97 #NUM! 10/02/72 Jun 9/1/86 Jan Any help will be much appreciated. Thanks. Marcia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display month name instead of number
=TEXT(C5,"mmm")
"Office User" wrote: I'm trying to display the month name abbreviation mmm instead of number. My date is in cell C5 in the formula examples below. If I use =TEXT(MONTH(C5),"mmm") I always get Jan no matter what the actual date (ie 7/30/84 or 1/27/84) If I use =TEXT(DATE(1900,C5,1),"mmm") I get a month name but not the right one. For example Actual Date Formula results 7/30/84 May 1/27/84 Dec 8/1/97 #NUM! 10/02/72 Jun 9/1/86 Jan Any help will be much appreciated. Thanks. Marcia |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display month name instead of number
On Tue, 9 Jan 2007 20:55:00 -0800, Office User
wrote: I'm trying to display the month name abbreviation mmm instead of number. My date is in cell C5 in the formula examples below. If I use =TEXT(MONTH(C5),"mmm") I always get Jan no matter what the actual date (ie 7/30/84 or 1/27/84) If I use =TEXT(DATE(1900,C5,1),"mmm") I get a month name but not the right one. For example Actual Date Formula results 7/30/84 May 1/27/84 Dec 8/1/97 #NUM! 10/02/72 Jun 9/1/86 Jan Any help will be much appreciated. Thanks. Marcia =TEXT(C5,"mmm") --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display month name instead of number
Thanks to both of you.
"Office User" wrote: I'm trying to display the month name abbreviation mmm instead of number. My date is in cell C5 in the formula examples below. If I use =TEXT(MONTH(C5),"mmm") I always get Jan no matter what the actual date (ie 7/30/84 or 1/27/84) If I use =TEXT(DATE(1900,C5,1),"mmm") I get a month name but not the right one. For example Actual Date Formula results 7/30/84 May 1/27/84 Dec 8/1/97 #NUM! 10/02/72 Jun 9/1/86 Jan Any help will be much appreciated. Thanks. Marcia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
