| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 into<g
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First day and Last day of the month to display automatically | Excel Discussion (Misc queries) | |||
| Display month name instead of number | Excel Discussion (Misc queries) | |||
| Display Month - 1 | Excel Worksheet Functions | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| i want to display the month from a date into another cell | Excel Worksheet Functions | |||
Linear Mode
