Highlight the colum with the dates in it. Then go up to format cells, pick
date according to the date order you want.


"tlc@OTS" wrote:

WE RECEIVE DATA FROM CANADA IN THE YY/MM/DD FORMAT AND I WOULD LIKE TO MAKE
THAT DATA IN MM/DD/YY FORMAT - IS THERE A WAY TO DO THIS AND NOT CHANGE THE
DATA ITSELF - BUT RATHER JUST THE WAY IT IS DISPLAYED??? HELP! ANY
SUGGESTIONS PLEASE??!!