See comments in-line.

On Thu, 24 Feb 2005 10:59:03 -0800, "TLH_HELP_DATE"
wrote:

ChelleA - that would be helpful but they do not allow me to choose that
format??

Who are "they"?

Also, sometimes when trying to put dates in, ie 032105- as it is formatted
for mm/dd/yy - it comes up as 11/24/87 ????? that is beyond me.

You can't enter a date in that manner without using code to covert it.

Dates must be entered with some type of separator like / or -

i just want to put the data - that comes to us as:

05/03/21 ---yy/mm/dd, march 21st, 2005

Excel will interpret that as March 5th, 2021 in my English(Canada) setup.

into
03/21/05 format.....mm/dd/yy

just can seem to figure this one out!!

For much more on Excel Dates and Times see Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben Excel MVP



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