ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date (https://www.excelbanter.com/excel-programming/304869-date.html)

No Name

Date

Hello,

I am having trouble formatting a date to show only the
current month. If I use Month(Now) then I get a number
value I would like to use the full month text format. I
have been trying to use the following code, but it is not
working.

Acval= Format(Month(Now), "mmmm")

Chip Pearson

Date

Use

Acval = Format(Now,"mmmm")

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

wrote in message
...

Hello,

I am having trouble formatting a date to show only the
current month. If I use Month(Now) then I get a number
value I would like to use the full month text format. I
have been trying to use the following code, but it is not
working.

Acval= Format(Month(Now), "mmmm")

No Name

Date

Thank You

-----Original Message-----
Use

Acval = Format(Now,"mmmm")

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

wrote in message
...

Hello,

I am having trouble formatting a date to show only the
current month. If I use Month(Now) then I get a number
value I would like to use the full month text format. I
have been trying to use the following code, but it is
not
working.

Acval= Format(Month(Now), "mmmm")

.

All times are GMT +1. The time now is 12:39 PM.