[vba]Dim mydate As Date
mydate = Date
mymonth = Left(mydate, 2)[/vba]
mydate = "8/10/2009"
mymonth = "8/"
Is there a way to force the month to have 2 numeral spaces (force a leading zero)?
[vba]Dim mydate As Date
mydate = Date
mymonth = Left(mydate, 2)[/vba]
mydate = "8/10/2009"
mymonth = "8/"
Is there a way to force the month to have 2 numeral spaces (force a leading zero)?
Office 2010, Windows 7
goal: to learn the most efficient way
Posting Permissions
Reply With Quote