| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert worksheet string name to date format in cell
Hello-
I have a workbook that will always have a sheet name such as 082509. I want to have cell J2 take that string and convert to a MM/DD/YY format. I tried the following, but it did not work: Range("J2").Select ActiveCell.FormulaR1C1 = DateValue(Format(Range(Worksheet (1)).Value, "00/00/00")) Any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert string to date | Excel Worksheet Functions | |||
| How I convert date formatt of dd/mm/yy to mm/yy (not cell format) | Excel Discussion (Misc queries) | |||
| Convert Date to STring | Excel Discussion (Misc queries) | |||
| Excel 2000 worksheet where I want to convert date format | Excel Discussion (Misc queries) | |||
| Can i convert numbers into string format? | Excel Discussion (Misc queries) | |||
Threaded Mode
