Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with Equation Display
I am a resonably experienced Excel user trying to use to enter some equations
into a new spreadsheet. Something's screwy because the cells where I typed my equations are displaying the equation and not the result. I tried doing things differently - using Excel to prod me to enter the equation, and even using simple equations like "=1/2" to try to get a numerical result. No luck, all I get is a text form of the equation. The Tools/Options/View/Formulas checkbox is clear, so that is not the problem. What can I have set wrong? Doug |
#2
|
|||
|
|||
Are the cells in question formatted as text? Try formatting them as
numbers, or currency, or General, and see if you get the desired results. |
#3
|
|||
|
|||
Those cells are probably formatted as Text (Format | Cells... | Number
tab). Format them as 'General' and then enter the formula. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am a resonably experienced Excel user trying to use to enter some equations into a new spreadsheet. Something's screwy because the cells where I typed my equations are displaying the equation and not the result. I tried doing things differently - using Excel to prod me to enter the equation, and even using simple equations like "=1/2" to try to get a numerical result. No luck, all I get is a text form of the equation. The Tools/Options/View/Formulas checkbox is clear, so that is not the problem. What can I have set wrong? Doug |
#4
|
|||
|
|||
Thanks guys,
I don't know how it happened, but you were both right. Changing the format to general fixed the problem. Doug "Tushar Mehta" wrote: Those cells are probably formatted as Text (Format | Cells... | Number tab). Format them as 'General' and then enter the formula. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am a resonably experienced Excel user trying to use to enter some equations into a new spreadsheet. Something's screwy because the cells where I typed my equations are displaying the equation and not the result. I tried doing things differently - using Excel to prod me to enter the equation, and even using simple equations like "=1/2" to try to get a numerical result. No luck, all I get is a text form of the equation. The Tools/Options/View/Formulas checkbox is clear, so that is not the problem. What can I have set wrong? Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link trendline equation in graph to cell? | Excel Discussion (Misc queries) | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |