Hi,

Choose Format, Cells, Number tab, Custom and enter YYYY on the Type line.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Soth" wrote:


Hi,

How do I format this below date to just a Year which i'm looking for?

3/31/2008
10/3/1996

Appreciat your help

Thanks
sothea