Harmonize date format

[rgoubet]

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]

Maybe you could record a macro when you try to get all the variations into one
category.

Select the range to fix
and edit|replace
what: . (dot)
with: / (slash)
replace all

Maybe a few mass changes would make all your entries consistent.

You may find that this actually changed the cells to dates and times.

(And if the original entries with slashes are text, just
edit|replace
what: / (slash)
with: / (slash)
replace all.

 

[Dave Peterson]

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