Custom format the cell as:
yy
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"yanu" wrote in message
...
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
|