display unabbreviated month in text, from system date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try this:

=TEXT(TODAY(),"MMMM")

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

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Put =NOW() into the cell in question. Set the formatting in the cell
to "mmmm" (no quotes).

Mark Lincoln
 
outasight! Thanks!!!

Ron Coderre said:
Try this:

=TEXT(TODAY(),"MMMM")

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

Regards,

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