Enter multiple dates at once

[dempseyj]

Hi, so I am working on a mac on sheets created on a windows. I need to sort by date, but since all the dates appear like 05/12/2010 (on the left side of the cell) they sort by the first number (the month) instead of the year. To fix this I must edit each cell and hit enter so the date appears like 5/12/10 (on the right side of the cell). But, since I am dealing with THOUSANDS of dates I cannot afford to go in once cell at a time and enter each one. Can I edit all of the dates at once?? Note: the dates are mostly different from each other.

 

[Jeffrey Lopez]

If they are on the left side of the cell, they are not formatted as dates, check the cell formats and make sure they are formatted as dates (rather than text). If that does not work, do a Text To Columns and see if that fixes it.

 

[dempseyj]

How do I check how the cells format? And what is a Text To Columns? Sorry I'm an excel noob.

 

[dempseyj]

How do I check how the cells format? And what is a Text To Columns? Sorry I'm an excel noob.

Ohh under Data. Thank you so much

 

[Jeffrey Lopez]

Great, glad you figured it out, and hope that helped!