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.