ExcelBanter - HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY? (https://www.excelbanter.com/excel-worksheet-functions/13776-how-do-i-format-data-yy-mm-dd-mm-dd-yy.html)

TLH_HELP_DATE

HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?

WE RECEIVE INFORMATION FROM CANADA WITH DATES IN THE YY/MM/DD FORMAT AND I
WOULD LIKE TO REFORMAT THEM TO BE IN THE MM/DD/YY FORMAT. CAN I DO THIS
WITHOUT CHANGING THE ACTUAL INFORMATION OF THE DATA - BUT JUST THE FORMAT
STYLE???? ANY SUGGESTIONS PLEASE!!

All times are GMT +1. The time now is 04:36 PM.