show month in text

[Mosaddeq Aziz]

hi,

if i enter the formula month(a1) where a1 is 14/02/2009. It shows 2. Is it
possible to show February?

Mosaddeq

 

[Ron Rosenfeld]

hi,

if i enter the formula month(a1) where a1 is 14/02/2009. It shows 2. Is it
possible to show February?

Mosaddeq

It is, but it would be simpler to use:

=text(a1,"mmmm")

or just use

=A1
and custom format the cell as mmmm
(Format/Cells/Number/Custom Type: mmmm)
--ron