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