Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula display - no results
I have a formula in a cell, but it did not calculate; however it displayed
the formula as though I had typed in text. Does anyone know what the problem might be? My Excel is set up to calculatie automatically. Thanks! -- Texas Wannano |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula display - no results
A couple of things to try.
Format the cell as General and reenter the formula. Make sure you don't have any spaces in front of the leading equal sign. Make sure you aren't looking at formulas: tools|options|view tab|Uncheck formulas Wannano wrote: I have a formula in a cell, but it did not calculate; however it displayed the formula as though I had typed in text. Does anyone know what the problem might be? My Excel is set up to calculatie automatically. Thanks! -- Texas Wannano -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula display - no results
Two possible reasons:
1. The cell is formatted as Text (Format-Cells then check the format in Number tab) 2. You have set the option to show formulas (Tools-Options then in the View tab, make sure "Formulas" is not checked.) -- Hope that helps. Vergel Adriano "Wannano" wrote: I have a formula in a cell, but it did not calculate; however it displayed the formula as though I had typed in text. Does anyone know what the problem might be? My Excel is set up to calculatie automatically. Thanks! -- Texas Wannano |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula display - no results
Thanks, it wasn't formatted as General.
-- Texas Wannano "Dave Peterson" wrote: A couple of things to try. Format the cell as General and reenter the formula. Make sure you don't have any spaces in front of the leading equal sign. Make sure you aren't looking at formulas: tools|options|view tab|Uncheck formulas Wannano wrote: I have a formula in a cell, but it did not calculate; however it displayed the formula as though I had typed in text. Does anyone know what the problem might be? My Excel is set up to calculatie automatically. Thanks! -- Texas Wannano -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
What is the formula to display a negative time results? | Excel Worksheet Functions | |||
Display the results not the formula in the task bar | Excel Worksheet Functions | |||
My DCOUNTA formula results do not display in Excel. | Excel Worksheet Functions | |||
How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) |