show month in text

  • Thread starter Thread starter Mosaddeq Aziz
  • Start date Start date
M

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
 
hi,

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

Mosaddeq
Click to expand...

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
 
Back
Top