| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas showing on worksheet
Pls help!
My formulas are showing on my worksheet and not showing the result It is not the audit function (Cntrl+`). For example: A1 2 A2 2 A3 =A1+A2 A3 shows =A1+A2 and not 4 Thoughts? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas showing on worksheet
go to 'tools'....'options'....'view tab' and make sure formulas does not have
a check mark in the box beside it. "Huber57" wrote: Pls help! My formulas are showing on my worksheet and not showing the result It is not the audit function (Cntrl+`). For example: A1 2 A2 2 A3 =A1+A2 A3 shows =A1+A2 and not 4 Thoughts? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas showing on worksheet
It gets more bizarre. Some of the cells in the spreadsheet will take a
formula, some won't. The 'Formulas' box does not have a check mark. Thoughts? "tim m" wrote: go to 'tools'....'options'....'view tab' and make sure formulas does not have a check mark in the box beside it. "Huber57" wrote: Pls help! My formulas are showing on my worksheet and not showing the result It is not the audit function (Cntrl+`). For example: A1 2 A2 2 A3 =A1+A2 A3 shows =A1+A2 and not 4 Thoughts? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas showing on worksheet
Some of your cells were text before you entered the formula. Format them all as General AND re-enter the formulas. This can easily
be done by Finding and replacing all "=" by "=". -- Kind regards, Niek Otten Microsoft MVP - Excel "Huber57" wrote in message ... | It gets more bizarre. Some of the cells in the spreadsheet will take a | formula, some won't. The 'Formulas' box does not have a check mark. | | Thoughts? | | "tim m" wrote: | | go to 'tools'....'options'....'view tab' and make sure formulas does not have | a check mark in the box beside it. | | "Huber57" wrote: | | Pls help! | | My formulas are showing on my worksheet and not showing the result | | It is not the audit function (Cntrl+`). | | For example: | A1 2 | A2 2 | A3 =A1+A2 | | A3 shows =A1+A2 and not 4 | | Thoughts? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas showing on worksheet
See if the cell is formatted as text, if so change it to either general or
number -- Regards, Peo Sjoblom "Huber57" wrote in message ... Pls help! My formulas are showing on my worksheet and not showing the result It is not the audit function (Cntrl+`). For example: A1 2 A2 2 A3 =A1+A2 A3 shows =A1+A2 and not 4 Thoughts? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas showing on worksheet
Thanks all!
I appreciate it. "Peo Sjoblom" wrote: See if the cell is formatted as text, if so change it to either general or number -- Regards, Peo Sjoblom "Huber57" wrote in message ... Pls help! My formulas are showing on my worksheet and not showing the result It is not the audit function (Cntrl+`). For example: A1 2 A2 2 A3 =A1+A2 A3 shows =A1+A2 and not 4 Thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas showing up as text | Excel Discussion (Misc queries) | |||
| formulas showing not value | Excel Discussion (Misc queries) | |||
| Formulas showing as text rather than values | Excel Discussion (Misc queries) | |||
| How can I print my excel worksheet showing formulas in the cells? | Excel Worksheet Functions | |||
| Formulas not showing results | Excel Worksheet Functions | |||
Hybrid Mode
