| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 olour display problem | Excel Discussion (Misc queries) | |||
| Display of Active Cell in MS Excel 2007 | Excel Discussion (Misc queries) | |||
| How can I display status bar value in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Text Box Display and Printing | Excel Discussion (Misc queries) | |||
| Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
Hybrid Mode
