|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 26th, 2007, 11:10 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
I want a the to display the Month name only. Nothing else.
I have a formula the following formula =EDATE(A3,1) that gives me a result of
"May-07" because the cell is formatted as: Catagory = Date Type = Mar-01 But I don't want the year to display, just the month. Any idea how I can do that? Thank you, DAIUTO 
|
|
#2
September 26th, 2007, 11:39 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
I want a the to display the Month name only. Nothing else.
Custom Format as mmm or mmmm for March
Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 15:10:03 -0700, DAiuto wrote: I have a formula the following formula =EDATE(A3,1) that gives me a result of "May-07" because the cell is formatted as: Catagory = Date Type = Mar-01 But I don't want the year to display, just the month. Any idea how I can do that? Thank you, DAIUTO
|
|
#3
September 26th, 2007, 11:56 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
I want a the to display the Month name only. Nothing else.
Is that all? I'm going in the other room to laugh at myself... sorry for
bothering all of you. : ) "Gord Dibben" wrote: Custom Format as mmm or mmmm for March Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 15:10:03 -0700, DAiuto wrote: I have a formula the following formula =EDATE(A3,1) that gives me a result of "May-07" because the cell is formatted as: Catagory = Date Type = Mar-01 But I don't want the year to display, just the month. Any idea how I can do that? Thank you, DAIUTO
|
|
#4
September 27th, 2007, 12:19 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
I want a the to display the Month name only. Nothing else.
Not a bother and you should see the number of rooms I've had to go intog
Gord On Wed, 26 Sep 2007 15:56:01 -0700, DAiuto wrote: Is that all? I'm going in the other room to laugh at myself... sorry for bothering all of you. : ) "Gord Dibben" wrote: Custom Format as mmm or mmmm for March Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 15:10:03 -0700, DAiuto wrote: I have a formula the following formula =EDATE(A3,1) that gives me a result of "May-07" because the cell is formatted as: Catagory = Date Type = Mar-01 But I don't want the year to display, just the month. Any idea how I can do that? Thank you, DAIUTO
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
