Try highlighting the column and then go up to data, text to columns,
delimited (next), check "keek delimeters as one" (next), then under column
data format tell it date, and pick the format that it was sent in (ie, YMD
year,month,date) then hit finish. It should then change from the format they
sent it in to MDY for you as the default for being in a date field. From
here you can format it thru the format section on your tool bar.


"ChelleA" wrote:

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