Apologies if this is redundant, I searched around for an answer on this but I just was having continued difficulty. Currently, I have open an excel spreadsheet, and am looking at a column that is giving me dates. However, there are two formats. The format MM/DD/YYYY and DD-MM-YYYY. However, when I highlight the entire column and select date, only the mm/dd/YYYY seem to change if I choose short or long term date. The dates in the dd-mm-YYYY do not respond no matter what. So far, I have attempted to click “data” and have tried text to columns, and that does not work. I have also tried replacing “-” with “/” but that won’t work either, and would still leave me the problem of the format being dd/mm/YYYY which is also incorrect still. For whatever reason, excel just does not recognize the dates in the dd-mm-YYYY and I am clueless as to why that is. Again, ultimately I just want all dates to be recognized and also in MM/DD/YYYY format. enter image description here

Apologies if this is redundant, I searched around for an answer on this but I just was having continued difficulty. Currently, I have open an excel spreadsheet, and am looking at a column that is giving me dates. However, there are two formats. The format MM/DD/YYYY and DD-MM-YYYY. However, when I highlight the entire column and select date, only the mm/dd/YYYY seem to change if I choose short or long term date. The dates in the dd-mm-YYYY do not respond no matter what. So far, I have attempted to click “data” and have tried text to columns, and that does not work. I have also tried replacing “-” with “/” but that won’t work either, and would still leave me the problem of the format being dd/mm/YYYY which is also incorrect still. For whatever reason, excel just does not recognize the dates in the dd-mm-YYYY and I am clueless as to why that is. Again, ultimately I just want all dates to be recognized and also in MM/DD/YYYY format. enter image description here

Apologies if this is redundant, I searched around for an answer on this but I just was having continued difficulty. Currently, I have open an excel spreadsheet, and am looking at a column that is giving me dates. However, there are two formats. The format MM/DD/YYYY and DD-MM-YYYY. However, when I highlight the entire column and select date, only the mm/dd/YYYY seem to change if I choose short or long term date. The dates in the dd-mm-YYYY do not respond no matter what. So far, I have attempted to click “data” and have tried text to columns, and that does not work. I have also tried replacing “-” with “/” but that won’t work either, and would still leave me the problem of the format being dd/mm/YYYY which is also incorrect still. For whatever reason, excel just does not recognize the dates in the dd-mm-YYYY and I am clueless as to why that is. Again, ultimately I just want all dates to be recognized and also in MM/DD/YYYY format. enter image description here

Apologies if this is redundant, I searched around for an answer on this but I just was having continued difficulty. Currently, I have open an excel spreadsheet, and am looking at a column that is giving me dates. However, there are two formats. The format MM/DD/YYYY and DD-MM-YYYY. However, when I highlight the entire column and select date, only the mm/dd/YYYY seem to change if I choose short or long term date. The dates in the dd-mm-YYYY do not respond no matter what. So far, I have attempted to click “data” and have tried text to columns, and that does not work. I have also tried replacing “-” with “/” but that won’t work either, and would still leave me the problem of the format being dd/mm/YYYY which is also incorrect still. For whatever reason, excel just does not recognize the dates in the dd-mm-YYYY and I am clueless as to why that is. Again, ultimately I just want all dates to be recognized and also in MM/DD/YYYY format. enter image description here