Thanks! it worked like a charm.


"RagDyer" wrote in message
...
If you truly have your present data as mmddyyy,
including the leading zeroes, you could try TTC.

Select the column of text dates, then:

<Data <Text To Columns <Next <Next
Under "Column Data Format", click on "Date",
And make sure "MDY" shows in the window.

Then <Finish.

This changes the column to true XL dates, where you can now simply format
the column to whatever date display you wish.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Peretz Stern" wrote in message
...
I have a sheet that has many rows with a date that looks like a text
format.
If I right click on the cell I can check it to a number and then to an
mm/dd/yyyy. My question is can I change all the rows to this format is
one
shot. I tried to choose the whole column and do a change format but that
didn't work. How would I go about changing mmddyyyy to mm/dd/yyyy?



Thanks,