View Single Post
  #1   Report Post  
Amir
 
Posts: n/a
Default perform caculations on displayed value in Excel 2000

how can i perform calculation in excel 2000 on displayed value instead of
stored value? e.g i have a dated written in a column formatted as 'yy' (i.e
04 etc). how can i add /subtract from this cell?