View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default custom date format

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

got to format cellsnumber tabcustom and enter this.....

mm-dd-yy

apply that to any column you wish.

Regards
FSt1

"jbclem" wrote:

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