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

 

[Harald Staff]

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.

 

[Ron Rosenfeld]

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