Excel 2007 Formula Display
 

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

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

Excel 2007 Formula Display
 

The format in cells F633 and F634 are text. I also tried changing it to
numbers but that did not solve the problem.
--
John


"papou" wrote:

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

Excel 2007 Formula Display
 

HI John,

Format the cell as General AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Training Spec." wrote in message
...
| 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

Excel 2007 Formula Display
 

See Niek's suggestion.

Cordially
Pascal
"Training Spec." a écrit dans le
message de news: ...
The format in cells F633 and F634 are text. I also tried changing it to
numbers but that did not solve the problem.
--
John


"papou" wrote:

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

Excel 2007 Formula Display
 

Thanks! That works.
--
John


"Niek Otten" wrote:

HI John,

Format the cell as General AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Training Spec." wrote in message
...
| 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