formatting date

  • Thread starter Thread starter Torrance Pollard
  • Start date Start date
T

Torrance Pollard

Hey,
is there any way to format this date 2005 so that it only shows the year
number 5
thanks
 
If you select the cells you want in date format, then right click on
them and select Format Cells and select the "number" tab, then select
Category, Date, you'll see all the date formats that come with XL. I
used to know how to create custom date formats, but it's been so long,
I don't remember how any more.
 

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

Back
Top