Thread: How do I fix: cell won't calculate because it is a constant?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I fix: cell won't calculate because it is a constant?
If the formula appears in both the formula bar and the cell, the problem is
usually that the cells have been formated to Text.

Clear the cell, format it to General, and re-enter the formula.
--
Gary''s Student - gsnu200822
Reply With QuoteReply With Quote