using a date format not in Excel 2002

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

jbclem

There is a common way of formatting dates, ie: 11-14-07, that doesn't seem to be included under the column/format
cells/number/date choice in my Excel 2002. I know I can input it by using an apostrophe first, but then it's listed as
an error. I'd like to make it the default and then find a macro that will let me create a column's worth of consecutive
dates.

Is there a way to do this...?

jc
 
Just figured this out myself. Go to Column/Format Cells/Number/Custom and enter mm-dd-yy. Simple as that. I didn't
think of this because I had tried custom formatting in Quatro Pro many times and could never get it to work. In Excel
it worked like a charm...glad I switched!

jc
 
You must log in or register to reply here.

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

custom date format 1
Date format in Excel 2002 1
Date Format not working 2
Date Formatting 2
Remove date format? 3
formatting dates 12
Using Dates with the IF function 2
Date Auto-detect & format Issues 2

Back
Top