Thread: Name of month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Name of month

Use MMMM rather than MM in your format string.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Fabrizio" wrote in message
...
I am making a macro that generates a report. I want to set the
title of the
report to the current month. I dont quite know how to use the
now property
(my help fuunction does not work). Code:

strDate1 = Format(Now, "YYYY-MM-DD")

with this I get the month (and day etc.) but I want to get the
month and be
able to show it in a cell. How do you do this? Is it possible
to the month in
another language? (my excel is in swedish and I wantb to get in
swedish).
Please help me!