custom date format

[jbclem]

I like to use this date format: 06-03-09 , but it isn't an option in my
Excel 2002 spreadsheet. I don't see it in FORMAT CELLS/DATE, or even in
FORMAT CELLS/CUSTOM . Can someone show me if and how I can format an entire
column to use this date format.

jc

 

[FSt1]

hi
maybe it's not there.....yet.

got to format cells>number tab>custom and enter this.....

mm-dd-yy

apply that to any column you wish.

Regards
FSt1

 

[smartin]

I like to use this date format: 06-03-09 , but it isn't an option in my
Excel 2002 spreadsheet. I don't see it in FORMAT CELLS/DATE, or even in
FORMAT CELLS/CUSTOM . Can someone show me if and how I can format an entire
column to use this date format.

jc

Select the cells, Format | Cells | Custom and enter mm-dd-yy. You can
specify pretty much any format you want here.