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.