View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default This drives me nuts

Hi
your cell is probably formated as 'Text'. Goto 'format - Cells' and
change the format to 'general'. After this reenter the formula

--
Regards
Frank Kabel
Frankfurt, Germany


Pete K wrote:
Am I the only person that gets this problem? Sometimes I will enter

a
formula in a cell and after I hit return it won't give the result of
the formula but will only display the formula. I will go to the cell
right next to it and do the exact same thing and it will then work
normally.

This drives me nuts.