View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default formula does not calculate

Check cell format! It is probably set to Text. Set it to General!

Just a little add-on to Stefi's note above (and as hinted in Steel Monkey's
response) ... The formula needs to be re-confirmed* before it'll work after
re-formatting to General (or Number). *Eg: click inside the formula bar,
press ENTER. The re-formatting alone will not fire the formula.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---