ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting the Date Format Being Used By The Operating System And Exc (https://www.excelbanter.com/excel-programming/345823-getting-date-format-being-used-operating-system-exc.html)

Sunnous

Getting the Date Format Being Used By The Operating System And Exc
 
Hi,

I wanted to know how within my VBA code I would be able to retreive the date
format being used by the OS and Excel, so I could use this to format my dates.

Thanks

Sunnous

Niek Otten

Getting the Date Format Being Used By The Operating System And Exc
 
I don't know how to get the string, but there are several named Date
Formats, like "Long Date", Medium Date" and "Short Date"

--
Kind regards,

Niek Otten

"Sunnous" wrote in message
...
Hi,

I wanted to know how within my VBA code I would be able to retreive the
date
format being used by the OS and Excel, so I could use this to format my
dates.

Thanks

Sunnous





All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com