Ooooh. And all that assumed that your windows short date was mm/dd/yyyy.

wrote:

Hi,

I export from an application csv reports for treatment in Excel.
However, the dates appearing in the CSV have can have several different
format, e.g.:

mm/dd/yyyy hh:mm
mm.dd.yyyy hh:mm

Is there a way to programmatically harmonize the date formats in a
selected range?

Thanks.

Raph

--

Dave Peterson