Date Format Issue

[Billy12excel]

Have received dates as listed below, under xls 2000 don't see a way to change, Want to change to 07-09-10

Excel Workbook
	A
1	DATE of DEATH
2	7/9/2010
3	8/7/2010
4	8/16/2011
5	8/20/2010
6	8/20/2010
7	8/20/2010
8	9/7/2010
9	9/13/2010
10	9/19/2010
11	9/20/2010
12	10/8/2010
13	11/1/2010
14	11/6/2010
15	11/6/2010
Sheet1

Excel 2000




Thank you in advance!

Billy

 

[Joe4]

Do you just want to change how they are displayed on your sheet?

As long as the dates are entered as dates and not text, all you have to do is highlight the column, bring up the Cell Formatting, go to Custom and enter a custom format of mm-dd-yy.

 

[Billy12excel]

Thank you, I appreciate that!