View Single Post
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

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