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

T

TLH_HELP_DATE

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format 10
How to enter a date in DD-MM-YYYY format 2
How to add day to PWA 2016 date format? 0
converting dd/mm/yy to mm/dd/yyyy 3
Change date format in Excel footer 2
can I change the date format as dd-mm-yy 7
Date Format 2
Forcing a date entry format of dd/mm/yyyy 1

Top