Date format problem

[Nishant]

Dear All,
Please suggest me the solution of my problem,
as i m handling data for 60,000 in no.Some body in data
entry has enter the date in a cell in gernal format e.g
20.03.2003 tht is 20th march 2003, i wnt to convert in the
date fomat,like 3/20/03.. i tried ..but i failed to tht
please suggest some alternative solution for tht..becoz it
is not possible to do it mannually

waiting for the response
Thanks
NISHANT

 

[Andy B]

Nishant

Try using Data/Text to Columns. and assign the information as a date.

Andy.

 

[Mark]

That's a lot of data for a spreadsheet!
If you can change the dates from 20.03.2003 to 20/03/2003
then Excel will recognise them as dates. You can then
change the Format of the cells using

Format > Cells > Number > Custom > mm/dd/yy

 

[Tim]

Andy! You da Man!
I'm going to use this!
It'll save me a ton of work!

 

[Dave Peterson]

I'd check my windows regional settings first.

Make sure the short date format is set to show dmy (in that order).

If my short date were mdy (typical USA), then after the change, the value was
still text.

If I changed my regional settings and did the change, it worked fine.