| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change date format
On Fri, 06 Feb 2004 04:01:20 GMT, "Warren" wrote:
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? Format(Activesheet.Range("A1"), "DD-MM-YY") --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change date format
sName = format(Range("a1").Value,"dd-mm-yy")
worksheets.Add Activesheet.Name = sName -- Regards, Tom Ogilvy Warren wrote in message news:kkEUb.185726$5V2.902591@attbi_s53... 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 |
| Reply |
| 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 | |||
Linear Mode
