display unabbreviated month in text, from system date?
 

How would one write a formula to enable a cell in a workbook to always
display the current month, in text format, unabbreviated, just by parsing the
system date - no input required from the user?

display unabbreviated month in text, from system date?
 

Try this:

=TEXT(TODAY(),"MMMM")

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"JustSomeGuy" wrote in message
...
How would one write a formula to enable a cell in a workbook to always
display the current month, in text format, unabbreviated, just by parsing
the
system date - no input required from the user?

display unabbreviated month in text, from system date?
 

Put =NOW() into the cell in question. Set the formatting in the cell
to "mmmm" (no quotes).

Mark Lincoln

On Oct 2, 2:14 pm, JustSomeGuy
wrote:
How would one write a formula to enable a cell in a workbook to always
display the current month, in text format, unabbreviated, just by parsing the
system date - no input required from the user?

display unabbreviated month in text, from system date?
 

outasight! Thanks!!!

"Ron Coderre" wrote:

Try this:

=TEXT(TODAY(),"MMMM")

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"JustSomeGuy" wrote in message
...
How would one write a formula to enable a cell in a workbook to always
display the current month, in text format, unabbreviated, just by parsing
the
system date - no input required from the user?