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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Convert Date in Text to month and Year 3
Excel Vba to change displayed year automatically. 14
Current Month with real date 2
Comparison of columns using Conditional Formatting 3
Month (MMM) from date (dd/mmm/yy) 1
Formula to figure out months between two dates 3
use month in cell date to sum all relevant cells 2

Back
Top