View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ah 3
 
Posts: n/a
Default display formula instead of its values in some cells

Hello all,

I encountered problem for some excel files when typing a formula but
displayed a formula instead of its calculated values, e.g.

when I entered "=100 + 100", what I exepected is to display as "200", but it
was displayed as "=100 + 100" instead.

Please kindly help, many thanks!