Hi Anitha

One way, with your number in A1, enter in B1
=DATE(1,A1,1)
and format cell B1 as FormatCellsCustom mmm

Date takes Date(Year,Month,Day) but we are not interested in the day or
year, hence 1 will suffice in each case.
The result will be 01 Jan 1901, but the format will cause it to show as
just Jan.

--
Regards

Roger Govier


"Anitha" wrote in message
...
I want to convert number to corresponding month eg., 1 Jan and so on