Thread
:
How can I pick up a two digit Month?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
How can I pick up a two digit Month?
Glad to help
--
Don Guillett
SalesAid Software
"Richard" wrote in message
...
It's working good.
thanks
"Don Guillett" wrote:
MsgBox Format(Date, "mm")
--
Don Guillett
SalesAid Software
"Richard" wrote in message
...
I'm trying to pcik up two digit month.
Example
Jan == 01
Feb == 02
below are the coding that I was trying to get the two digit month, but
it
is
not working.
Thanks
Dim strMonth as String
strMonth = format(month(now()), ##)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett