"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
|