| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Fromula showing as text but not value
When I type a formula in my spreadsheet it appears as the text of the formula
but not as the calculated value. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
Format cell as General
"Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
There are a couple reasons why this might be happening.
Make sure "Display Formulas" is turned off: Go to TOOLS, then OPTIONS, then VIEW Tab Make sure "Formulas" is not checked Make sure the cell you're entering the formula into is not formatted as Text: Select the cell From the Format Menu, choose "Cells..." On the Number Tab, choose "General" as your category Click OK Re-enter the formula (you can just hit F2 then Enter. HTH, Elkar "Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
Elkar,
Thanks, I think that did it! Much appreciated! Paul "Elkar" wrote: There are a couple reasons why this might be happening. Make sure "Display Formulas" is turned off: Go to TOOLS, then OPTIONS, then VIEW Tab Make sure "Formulas" is not checked Make sure the cell you're entering the formula into is not formatted as Text: Select the cell From the Format Menu, choose "Cells..." On the Number Tab, choose "General" as your category Click OK Re-enter the formula (you can just hit F2 then Enter. HTH, Elkar "Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
Hi Elkar,
I spoke too soon. It worked briefly and then converted back to the formula again. The cell doesn't seem to want to stay formatted as general. It switched back to text. I think that is why it doesn't calculate the formula. Any ideas? Paul "Elkar" wrote: There are a couple reasons why this might be happening. Make sure "Display Formulas" is turned off: Go to TOOLS, then OPTIONS, then VIEW Tab Make sure "Formulas" is not checked Make sure the cell you're entering the formula into is not formatted as Text: Select the cell From the Format Menu, choose "Cells..." On the Number Tab, choose "General" as your category Click OK Re-enter the formula (you can just hit F2 then Enter. HTH, Elkar "Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
That is strange. How is this formula entered? Do you Copy/Paste? Is it
created by a macro? Is there any VB coding at all in your workbook? Not sure what else it could be. "Paul" wrote: Hi Elkar, I spoke too soon. It worked briefly and then converted back to the formula again. The cell doesn't seem to want to stay formatted as general. It switched back to text. I think that is why it doesn't calculate the formula. Any ideas? Paul "Elkar" wrote: There are a couple reasons why this might be happening. Make sure "Display Formulas" is turned off: Go to TOOLS, then OPTIONS, then VIEW Tab Make sure "Formulas" is not checked Make sure the cell you're entering the formula into is not formatted as Text: Select the cell From the Format Menu, choose "Cells..." On the Number Tab, choose "General" as your category Click OK Re-enter the formula (you can just hit F2 then Enter. HTH, Elkar "Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
Has anyone solved this? I am having the same problem. When I display the
formula in the formula editor I can see the correct result however in my spreadsheet all I see if the formula text. Thank you, LindaSue "Elkar" wrote: That is strange. How is this formula entered? Do you Copy/Paste? Is it created by a macro? Is there any VB coding at all in your workbook? Not sure what else it could be. "Paul" wrote: Hi Elkar, I spoke too soon. It worked briefly and then converted back to the formula again. The cell doesn't seem to want to stay formatted as general. It switched back to text. I think that is why it doesn't calculate the formula. Any ideas? Paul "Elkar" wrote: There are a couple reasons why this might be happening. Make sure "Display Formulas" is turned off: Go to TOOLS, then OPTIONS, then VIEW Tab Make sure "Formulas" is not checked Make sure the cell you're entering the formula into is not formatted as Text: Select the cell From the Format Menu, choose "Cells..." On the Number Tab, choose "General" as your category Click OK Re-enter the formula (you can just hit F2 then Enter. HTH, Elkar "Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Fromula showing as text but not value
Did you change the format in the cell to something other than text and after
doing this did you select the cell and press F2 and enter. If it is still text the workbook might be corrupted, I would copy the data to a new workbook -- Regards, Peo Sjoblom "LindaSue" wrote in message ... Has anyone solved this? I am having the same problem. When I display the formula in the formula editor I can see the correct result however in my spreadsheet all I see if the formula text. Thank you, LindaSue "Elkar" wrote: That is strange. How is this formula entered? Do you Copy/Paste? Is it created by a macro? Is there any VB coding at all in your workbook? Not sure what else it could be. "Paul" wrote: Hi Elkar, I spoke too soon. It worked briefly and then converted back to the formula again. The cell doesn't seem to want to stay formatted as general. It switched back to text. I think that is why it doesn't calculate the formula. Any ideas? Paul "Elkar" wrote: There are a couple reasons why this might be happening. Make sure "Display Formulas" is turned off: Go to TOOLS, then OPTIONS, then VIEW Tab Make sure "Formulas" is not checked Make sure the cell you're entering the formula into is not formatted as Text: Select the cell From the Format Menu, choose "Cells..." On the Number Tab, choose "General" as your category Click OK Re-enter the formula (you can just hit F2 then Enter. HTH, Elkar "Paul" wrote: When I type a formula in my spreadsheet it appears as the text of the formula but not as the calculated value. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fromula | Excel Discussion (Misc queries) | |||
| I just want to print an excel sheet showing gridlines with no text | New Users to Excel | |||
| Need a fromula | Excel Discussion (Misc queries) | |||
| I have text in an Excel Cell that isn't showing all of it? | Excel Discussion (Misc queries) | |||
| Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Hybrid Mode
