| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
