show character value of a month rather than numeric?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jim sturtz - 17 Jan 2006 19:41 GMT

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

thanks.

jim

microsoft.public.excel.newusers

Reply to this Message

Ragdyer - 17 Jan 2006 19:47 GMT

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> the month function gives me 1 for the value of month(today()), can i get
> january instead?
[quoted text clipped - 4 lines]
>
> microsoft.public.excel.newusers

Reply to this Message

Ron Coderre - 17 Jan 2006 20:05 GMT

Try this:

=TEXT(TODAY(),"mmmm")

Does that help?

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

XL2002, WinXP-Pro

> the month function gives me 1 for the value of month(today()), can i get
> january instead?
[quoted text clipped - 4 lines]
>
> microsoft.public.excel.newusers

Reply to this Message

Kevin Lehrbass - 17 Jan 2006 20:16 GMT

Hi Jim,

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

Cheers,

Kevin Lehrbass
kevin@spreadsheetsolutions4u.com
www.spreadsheetsolutions4u.com

> the month function gives me 1 for the value of month(today()), can i get
> january instead?
[quoted text clipped - 4 lines]
>
> microsoft.public.excel.newusers

Reply to this Message

jim sturtz - 17 Jan 2006 20:40 GMT

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

thanks.

> the month function gives me 1 for the value of month(today()), can i get
> january instead?
[quoted text clipped - 4 lines]
>
> microsoft.public.excel.newusers

Reply to this Message