Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change date format
Can someone please help?
The macro I am writing reads in a date from Cell A1, which is formatted as dd/mm/yy. I want to create a new sheet with this date as the name. I know that the sheet name cannot have "/" in it. The sheet is protected and I cannot unprotect it. So what is the code to read in this date and convert it to a text string in the format of dd-mm-yy? Thanks in advance Warren |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |