Date/Text Formatting

[Tappie]

Hi,

I have a column with in date format and would like to get
this into a text format as follows :

Column would say : 01/03/04

I want text to say : 'The month is March'

Any help would be appreciated...

Thanks

Tappie

 

[Max]

One way ..

Assuming dates are in col A, A1 down

Put in B1:
="The month is
"&CHOOSE(MONTH(A1),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oc
t","Nov","Dec")

Copy down

 

[Domenic]

="The month is "&TEXT(A1,"mmmm")

Hope this helps!

 

[Max]

Much simpler, Domenic !
cheers

 

[Guest]

Thanks all....

-----Original Message-----
="The month is "&TEXT(A1,"mmmm")

Hope this helps!


.