show character value of a month rather than numeric?

[jim sturtz]

the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers

 

[Ragdyer]

Just use
=TODAY()
And custom format the cell to
mmm

 

[Guest]

Try this:

=TEXT(TODAY(),"mmmm")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

Hi Jim,

Try this formula:
=CHOOSE(MONTH(TODAY()),"January","February","March","April","May","June","July","August","September","October","November","December")

Cheers,

Kevin Lehrbass
(e-mail address removed)
www.spreadsheetsolutions4u.com

 

[jim sturtz]

whatta group, now which do i take door#1 or ....

thanks.