"3" TO MARCH OR "11" TO NOVEMBER
 

Hi

Is there an easy method in VBA to convert m% to m$
where m%=3 and m$ should be "march"

Thanks

Sunil

"3" TO MARCH OR "11" TO NOVEMBER
 

Using Excel 2002:

m$ = MonthName(m%)

K


---
Message posted from http://www.ExcelForum.com/

"3" TO MARCH OR "11" TO NOVEMBER
 

Sunil,

Dim m As Integer
m = 3
MsgBox Format(DateValue(m & "/1/2004"), "mmmm")

HTH,
Bernie
MS Excel MVP

"SUNIL PATEL" wrote in message
...
Hi

Is there an easy method in VBA to convert m% to m$
where m%=3 and m$ should be "march"

Thanks

Sunil

"3" TO MARCH OR "11" TO NOVEMBER
 

Hi Bernie

In most of Eurpoe this equals
MsgBox "january".
Allow me to suggest
MsgBox Format(DateSerial(2004, m, 1), "mmmm")

HTH. Best wishes Harald

"Bernie Deitrick" <deitbe @ consumer dot org skrev i melding
...
Sunil,

Dim m As Integer
m = 3
MsgBox Format(DateValue(m & "/1/2004"), "mmmm")

HTH,
Bernie
MS Excel MVP

"SUNIL PATEL" wrote in message
...
Hi

Is there an easy method in VBA to convert m% to m$
where m%=3 and m$ should be "march"

Thanks

Sunil

"3" TO MARCH OR "11" TO NOVEMBER
 

Hi!

Or:

MsgBox Format(m*29, "mmmm")


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia