display year?

[srananmeitie]

Is it possible to format a date (14-march-01) to display only the year, ie 2001 in this case?


Thanks

 

[golf4]

Hi -

Give this a try:

1. Right click on the cell you want to format;
2. Choose Format Cells;
3. Select the Custom option;
4. Instead of choosing one of the selections, type yyyy in the field under the word "Type:";

This should do it for you.

HTH,

Frank

 

[2rrs]

Is it possible to format a date (14-march-01) to display only the year, ie 2001 in this case?


Thanks

Custom format "yyyy"

 

[srananmeitie]

What a simple solution!

Thanks so much