View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francis Ang[_3_] Francis Ang[_3_] is offline
external usenet poster
 
Posts: 75
Default 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.