Thread
:
How can I pick up a two digit Month?
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
How can I pick up a two digit Month?
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