Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to append the current date-time into a string
without slashes ("/") or dots ("."), to use as a filename. I have passed the Date function to a variable, but can't easily convert the format without parsing the string to remove the slashes. Is there an easy way to convert it to the native numeric format Excel uses internally (that would work fine, I just need a date string to differentiate filenames), or any otehr format that would work in a filename? There must be an easier/faster way than parsing this. thanks kpd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |