|
|
#1
04-20-2021, 10:04 AM
|
|||
|
|||
Convert NowMonth MonthNow to double digits mm
How do I convert / format the month name of a SHEET / TAB to be double digits rather than single?
It currently produces: "2021-3" but need "2021-03" Code:
Sub InsertNewWorksheetAndName()
nowMonth = Month(Now) - 1
nowYear = Year(Now)
ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count)
ActiveWorkbook.Sheets(Worksheets.Count).Name = nowYear & "-" & nowMonth
End Sub
|
| Tags |
| monthnow nowmonth mm |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Find last three digits after . ( including zero)
|
LearnerExcel | Excel | 4 | 02-08-2018 10:49 AM |
| Having number's digits together | mohsen.amiri | Word | 0 | 06-23-2017 01:20 AM |
|
Need help calculating frequency of digits
|
laucn | Excel | 2 | 06-08-2015 07:50 AM |
| Separate the digits into 3 combinations | Jasa P | Word VBA | 1 | 08-19-2012 11:04 PM |
|
Problems merging in last 4 digits of an account higher than 16 digits
|
Glynda | Mail Merge | 1 | 04-08-2011 12:17 AM |
Windows 10 
Office 2019
Threaded Mode