Display current month in alpha

  • Thread starter Thread starter Pen
  • Start date Start date
P

Pen

I would like a monthly report to Display the current month in alpha
characters, e.g. "January" rather than "01".

Your help is much appreciated!

Pen
 
What ever you use to display the month (yourmonth) use:

=format(yourmonth, "mmmm")

eg.The current month would be : =format(now(), "mmmm")
 
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

Excel Vba to change displayed year automatically. 14
Month order on Report 8
Excel Excel IF variable based on time of day 0
Using Access 2003 convert numeric month to text for reports 2
Faking Section Headers for Months of Year 1
Display Current Month 2
Corsair Carbide Spec-Alpha Case 1
CREATING A REPORT TO GATHER DATA FROM CURRENT OR LAST MONTH ENTRIE 3

Back
Top