Hello All,
Using Excel 2007

Question - can some member supply me with the formula to do this

In A1 is the date 30/04/2009 ( UK format ) and in A3 I want to display the
month like this "APR" to 3 chars,based on A1. If the date in A1 had been
31/10/2009 then I want A3 to display "OCT" ... and so on

Thanks in advance of offers of help

--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

Two methods

In another cell put the formula =A1 and formta that cell as mmm

or in another cell

=TEXT(A1,"mmm")

Note that if you add another m to the last formula you get the full month
name.

Mike

"Finance Guru" wrote:

Hello All,
Using Excel 2007

Question - can some member supply me with the formula to do this

In A1 is the date 30/04/2009 ( UK format ) and in A3 I want to display the
month like this "APR" to 3 chars,based on A1. If the date in A1 had been
31/10/2009 then I want A3 to display "OCT" ... and so on

Thanks in advance of offers of help

--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,


Can do it using VBA, put the below code:

Range("A3").FormulaR1C1 = Format(Range("A1"), "mmm")


Good Luck,
Sanjay

--If post is helpfun then click Yes--


"Finance Guru" wrote:

Hello All,
Using Excel 2007

Question - can some member supply me with the formula to do this

In A1 is the date 30/04/2009 ( UK format ) and in A3 I want to display the
month like this "APR" to 3 chars,based on A1. If the date in A1 had been
31/10/2009 then I want A3 to display "OCT" ... and so on

Thanks in advance of offers of help

--
Wales - the land of fire breathing dragons and rugby playing wizards.

=UPPER(TEXT(A1,"mmm"))
--
David Biddulph

"Finance Guru" wrote in message
...
Hello All,
Using Excel 2007

Question - can some member supply me with the formula to do this

In A1 is the date 30/04/2009 ( UK format ) and in A3 I want to display the
month like this "APR" to 3 chars,based on A1. If the date in A1 had been
31/10/2009 then I want A3 to display "OCT" ... and so on

Thanks in advance of offers of help

--
Wales - the land of fire breathing dragons and rugby playing wizards.

Thanks Guys for the replies. Mike's did it for me,however I had already
sussed out the UPPER() bit of David's as that was what I wanted. Sanjay
thanks also.

Much appreciated


--
Wales - the land of fire breathing dragons and rugby playing wizards.


"Mike H" wrote:

Hi,

Two methods

In another cell put the formula =A1 and formta that cell as mmm

or in another cell

=TEXT(A1,"mmm")

Note that if you add another m to the last formula you get the full month
name.

Mike

"Finance Guru" wrote:

Hello All,
Using Excel 2007

Question - can some member supply me with the formula to do this

In A1 is the date 30/04/2009 ( UK format ) and in A3 I want to display the
month like this "APR" to 3 chars,based on A1. If the date in A1 had been
31/10/2009 then I want A3 to display "OCT" ... and so on

Thanks in advance of offers of help

--
Wales - the land of fire breathing dragons and rugby playing wizards.

Besides using the Format function, you can also do this...

Range("A4").Formula = MonthName(Month(Range("A1").Value), True)

--
Rick (MVP - Excel)


"Sanjay" wrote in message
...
Hi,


Can do it using VBA, put the below code:

Range("A3").FormulaR1C1 = Format(Range("A1"), "mmm")


Good Luck,
Sanjay

--If post is helpfun then click Yes--


"Finance Guru" wrote:

Hello All,
Using Excel 2007

Question - can some member supply me with the formula to do this

In A1 is the date 30/04/2009 ( UK format ) and in A3 I want to display
the
month like this "APR" to 3 chars,based on A1. If the date in A1 had been
31/10/2009 then I want A3 to display "OCT" ... and so on

Thanks in advance of offers of help

--
Wales - the land of fire breathing dragons and rugby playing wizards.