Detecting date format
 

A good day to all!

I was wondering whether is there a way to detect what is the date format
setting using VBA i.e. was the date set as ddmmyy or mmddyy?

Any help is very much appreciated.

Thank you.

Detecting date format
 

Francis,
Range("A1").NumberFormat

NickHK

"Francis Ang" wrote in message
...
A good day to all!

I was wondering whether is there a way to detect what is the date format
setting using VBA i.e. was the date set as ddmmyy or mmddyy?

Any help is very much appreciated.

Thank you.