PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting formatting dates by year

Reply

formatting dates by year

 
Thread Tools Rate Thread
Old 09-02-2004, 03:47 PM   #1
DKD
Guest
 
Posts: n/a
Default formatting dates by year


I would like to know if there is a way to format dates so
that they are formatted by year only. For example, if I
click on Format -> Cells, there are a bunch of options,
but none of them list to show the year only, just
mm/dd/yy or mm/yy, etc. I am trying to create a chart so
that only the year shows up. Also, I have tried doing
Custom->and "yyyy" in type, but only 1 specific year
shows up (i.e. 1905) for all the values. I would like to
keep my values.

Thanks much!



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off