PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
formatting dates by year
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
formatting dates by year
![]() |
formatting dates by year |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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! |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

