Date Format problem

  • Thread starter Thread starter Nishant
  • Start date Start date
N

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
..
 
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.
 
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
.
Click to expand...

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
 
Back
Top