Date cells after conversion from Database

[Rene]

In our organisation we are dealing with different date
formats (dd/mm/yyyy or mm/dd/yy) When information is
requested out of our JDE database it is presented as a
csv file. After convertion into Excel the 'dd/mm/yyyy'
are recognised as date formats, but the 'mm/dd/yy' only
as general formats. How do I change those last ones in
recogniseable date formats?

Thanks for your help!!!!

Rene.

 

[clane]

if you can highlight them all then right click and choose format cells
then under the number tab choose custom then enter mm/dd/yy in the to
box. that might help


cheer

 

[Guest]

Thanks for your help! I've tried that, but although the
formatting shows 'date' it's not picked up (i.e. when you
change the formatting of a 'real' date cell to general,
you'll get a number (the value), however that doesn't
work with the 're-formatted' cells.

 

[Myrna Larson]

Then the 'dates' have been interpreted as text. To convert to 'real' dates,
Edit/Copy a blank cell. Then select the cells containing the dates and
Edit/Paste Special and select the Values and Add options.

 

[Rene]

Thanks Myrna, that fixed it perfectly! Have a good one,
Rene.