View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
 
Posts: 179
Default formula does not calculate

Select entire column and go Data--Text to Column, then just click finish.
your problem will solve.

"TaiwanSwede" wrote:

Help!

Something is weird with my Excel sheet. When I enter a formula, for example
=AB2+AB3
Excel does not calculate the result. Instead the formula just stays as it
is. I am sure there is some strange option that has been chosen by accident,
but I can't come up with where.

Any help out there!