| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
View formula result instead of formula
Sometimes when I type in a formula, the cell displays the formula and not the
result. How do I get it to show the result instead of the formula? Is this a setting somewhere? It doesn't happen all the time. Thanks in advance!! -- Tina |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
View formula result instead of formula
Hi Tina,
This happens if you type the formula in a cell that is already formatted as text. Format as general and re-enter the formula (F2,ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Tina" wrote in message ... | Sometimes when I type in a formula, the cell displays the formula and not the | result. How do I get it to show the result instead of the formula? Is this | a setting somewhere? It doesn't happen all the time. | | Thanks in advance!! | -- | Tina |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
View formula result instead of formula
As you type it in or click on it later it will show the formula.
If *all your cells* show formula then type Ctrl+` Steve On Wed, 04 Oct 2006 13:48:01 +0100, Tina wrote: Sometimes when I type in a formula, the cell displays the formula and not the result. How do I get it to show the result instead of the formula? Is this a setting somewhere? It doesn't happen all the time. Thanks in advance!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
View formula result instead of formula
Thank you for responding so quickly!! This worked perfectly. Thanks again.
:-) -- Tina "Niek Otten" wrote: Hi Tina, This happens if you type the formula in a cell that is already formatted as text. Format as general and re-enter the formula (F2,ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Tina" wrote in message ... | Sometimes when I type in a formula, the cell displays the formula and not the | result. How do I get it to show the result instead of the formula? Is this | a setting somewhere? It doesn't happen all the time. | | Thanks in advance!! | -- | Tina |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
View formula result instead of formula
I couldn't view the replies because €śerror on page€ť, what can I do?
"Tina" wrote: Sometimes when I type in a formula, the cell displays the formula and not the result. How do I get it to show the result instead of the formula? Is this a setting somewhere? It doesn't happen all the time. Thanks in advance!! -- Tina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
| how to use spellnumber formula | Excel Worksheet Functions | |||
| Currency to Text | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Linear Mode
