custom date format

  • Thread starter Thread starter jbclem
  • Start date Start date
J

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
Conditional Formatting - Dates 2
Column Date Format 1
Conditional formatting in Excel 2010 2
Why this paste result? 4
Excel 2007 displayed dates 2
formatting dates 12
Date format 8

Back
Top