Thread
:
Excel 2007 Formula Display
View Single Post
#
2
Posted to microsoft.public.excel.misc
papou
external usenet poster
Posts: 110
Excel 2007 Formula Display
Hello
Did you check the cell format?
HTH
Cordially
Pascal
"Training Spec." a écrit dans le
message de news:
...
All formulas display their solutions in their cells except for 2 cells
(F633
and F634) which display their formulas. The formula, which is
=COUNTIF(G7:G629,"E"), works fine if I place it in another cell! The
original
workbook was created in an earlier version of Excel (unknown version) but
it
worked fine in Excel 2003. Changing the workbook from Compatibility Mode
to
Excel 2007 (.xlsm) did not solve the problem.
Thanks!
--
John
Reply With Quote
papou
View Public Profile
Find all posts by papou