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,