[SOLVED] show character value of a month rather than numeric?

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

thanks.

jim

microsoft.public.excel.newusers

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jim sturtz" <[email protected]> wrote in message
news:[email protected]...
> the month function gives me 1 for the value of month(today()), can i get
> january instead?
>
> thanks.
>
> jim
>
> microsoft.public.excel.newusers
>
>
>

Try this:

=TEXT(TODAY(),"mmmm")

Does that help?

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

XL2002, WinXP-Pro


"jim sturtz" wrote:

> the month function gives me 1 for the value of month(today()), can i get
> january instead?
>
> thanks.
>
> jim
>
> microsoft.public.excel.newusers
>
>
>
>

Hi Jim,

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

Cheers,

Kevin Lehrbass
[email protected]
www.spreadsheetsolutions4u.com


"jim sturtz" wrote:

> the month function gives me 1 for the value of month(today()), can i get
> january instead?
>
> thanks.
>
> jim
>
> microsoft.public.excel.newusers
>
>
>
>

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

thanks.

"jim sturtz" <[email protected]> wrote in message
news:[email protected]...
> the month function gives me 1 for the value of month(today()), can i get
> january instead?
>
> thanks.
>
> jim
>
> microsoft.public.excel.newusers
>
>
>