Date Format problem

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
..

Hi Nishant

Question is; are the entries interpreted by Excel as real dates ? Choose one
of the date cells, go enu Format Cells and pick another date format. If it
works then all you have to do is this for the whole range of cells.

--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

"Nishant" skrev i melding
...
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
.

On Tue, 16 Sep 2003 23:36:38 -0700, "Nishant" wrote:

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
.


First, back up your data.

If the dates are all in a column:

1. Select the range of Dates
2. Select Data/Text to Columns
Next/Next
3. Column Data Format/Date: DMY
4. Finish

HTH,

--ron