Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert an Excel date to a date of my format in VBA
Hello,
I would be grateful if someone was able to help me with a date conversion issue. I want to be able to convert an Excel date to date of my format. But without sending or displaying anything in the spreadsheet. Once the date is converted I want to display it in a ListView and will not be displayed within spreadsheet. So I would appreciate your help on this matter, I have looked on the web and looked at VBA functions but no joy. Many Thanks Sunnous |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert an Excel date to a date of my format in VBA
? format(12345,"mmm dd, yyyy")
Oct 18, 1933 ? clng(dateSerial(2005,11,15)) 38671 Dates are stored as the number of dates from a base date. In windows 1900. In Mac 1904 are the defaults. -- Regards, Tom Ogilvy "Sunnous" wrote in message ... Hello, I would be grateful if someone was able to help me with a date conversion issue. I want to be able to convert an Excel date to date of my format. But without sending or displaying anything in the spreadsheet. Once the date is converted I want to display it in a ListView and will not be displayed within spreadsheet. So I would appreciate your help on this matter, I have looked on the web and looked at VBA functions but no joy. Many Thanks Sunnous |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert US date with 12hr format to European date 24hr | Excel Discussion (Misc queries) | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming |