display unabbreviated month in text, from system date?

J

JustSomeGuy

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?
 
R

Ron Coderre

Try this:

=TEXT(TODAY(),"MMMM")

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

Regards,

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

Mark Lincoln

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

Mark Lincoln
 
B

Bob W

outasight! Thanks!!!

Ron Coderre said:
Try this:

=TEXT(TODAY(),"MMMM")

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

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
Click to expand...
 
Top