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

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




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