There is a function to show the number of the 1-12. Is there a way to
show the name?

=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
--
David Biddulph


"pat67" wrote in message
...
There is a function to show the number of the 1-12. Is there a way to
show the name?

On May 24, 3:55*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
--
David Biddulph

"pat67" wrote in message

...



There is a function to show the number of the 1-12. Is there a way to
show the name?- Hide quoted text -

- Show quoted text -

Thanks

=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1

If you have just the month number 1 to 12:

=TEXT(A1*29,"mmmm")

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
--
David Biddulph


"pat67" wrote in message
...
There is a function to show the number of the 1-12. Is there a way to
show the name?

If a cell is displaying a date (let's say 1/1/2010) and I give it the custom
format of "mmm" (without quotes) will display the month name abbreviation
A custom format of "mmm" will display the full name
Suppose A1 holds a date and B1 has =A1, then the custom formatting will show
the name of month as above
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/o...ult.aspx#tab=4

"pat67" wrote in message
...
There is a function to show the number of the 1-12. Is there a way to
show the name?

other way, just formating a cell without a text formula

right click on the cell, go to format cells, choose custom and give mmmm

all the best