You can go to Format Cells, from "Number" tab select "Custom", in "Type"
filed type mmm or mm (as you prefer) and press OK.
--
Regards,
Pritesh


"deepak" wrote:

Hello!

1 Suppose A1 has date in format dd-mm-yy , say 12-DEC-09. How can I have
extract only DEC from A1?

2 I get stucked whenever there is more than eight IF in the neseted IF
statement. Cannot we have more than 8 IF?

Please help me out.

Thanking you.