View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Find Date in different format

Hello,

My column A contain dates from Jan 20 2009 till Jan 25 2009. Depending on
the computer (Windows settings / Excel settings), dates will be formated
differrenly: 2009-01-20 or 1/20/2009 or........ Date from the database comes
in 2009-01-20 format. I need to find date from the database in the column A.
Can I use Application.FindFormat for that? NumberFormat?
Another question, how I can retrieve this date settings from Excel? (I can
convert database's date format to Excel's).

Thank you very much.