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()), ##) |
All times are GMT +1. The time now is 07:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com