| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VB - copying formatted dates programatically
I am assuiming you have an actual date and not a string to be converted.
dim strDate as string strdate = format(range("A1").value, "yymmdd") -- HTH... Jim Thomlinson "Glenn" wrote: I have a date field with "yymmdd" format. I want to programatically convert that to text that looks identical to the formatted date for use in dimensioned variables/strings. e.g. - date 6/10/2008 formatted looks like "080610". I want to use a/the text string "080610" for various other uses. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) | Excel Discussion (Misc queries) | |||
| copying part of a cell's contents (formatted as dd:hh:mm) | Excel Worksheet Functions | |||
| Programatically copy cells with dates | Excel Programming | |||
| Dates in Excel - yyyymmdd, not formatted, how do I format this? | Excel Discussion (Misc queries) | |||
| Copying Formats vs Formatting Programatically | Excel Programming | |||
Threaded Mode
