Hi

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

Thanks

Sunil

Using Excel 2002:

m$ = MonthName(m%)

K


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

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

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

Hi!

Or:

MsgBox Format(m*29, "mmmm")


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