![]() |
Why does the formula show instead of the result?
Instead of the result of a formula showing up in the cell, the formula itself
is displayed. |
Why does the formula show instead of the result?
Does this happen to all formulas or just one? The cell is likely
formatted as Text. Change the format to General and then select the cell. Press F2 then Enter. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "carpfish" wrote in message ... Instead of the result of a formula showing up in the cell, the formula itself is displayed. |
Why does the formula show instead of the result?
sounds like you either forgot the "=" in front of your formula or it is
formatted as text HTH Die_Another_Day carpfish wrote: Instead of the result of a formula showing up in the cell, the formula itself is displayed. |
Why does the formula show instead of the result?
HI
tools | options | view | Formula hth regards from Brazil Marcelo "carpfish" escreveu: Instead of the result of a formula showing up in the cell, the formula itself is displayed. |
All times are GMT +1. The time now is 12:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com