| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula stays visible in cell
When I entered a formula into a cell it stays visible. I have tried several
different styles of format and the only change I have been able to get resulted in a #ref error. Any ideas would help. Thanks Trev |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula stays visible in cell
Try formatting the cell as General (or anything but text).
Then reenter the formula. Or Try tools|Options|View tab|and uncheck Formulas (xl2003 menus) Trev wrote: When I entered a formula into a cell it stays visible. I have tried several different styles of format and the only change I have been able to get resulted in a #ref error. Any ideas would help. Thanks Trev -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula stays visible in cell
The cell may have been formatted as text before the formula was entered.
Select the cell, then right-click and select Format Cells. Format the cell as General (on the Number tab), then click OK. Press F2, then Enter. Another possibility is that you have accidentally toggled the view to display formulas rather than their results. Pressing Ctrl ` to toggle the view back to normal (` is to the left of the number 1). Hope this helps, Hutch "Trev" wrote: When I entered a formula into a cell it stays visible. I have tried several different styles of format and the only change I have been able to get resulted in a #ref error. Any ideas would help. Thanks Trev |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula stays visible in cell
I am using 2007.
"Dave Peterson" wrote: Try formatting the cell as General (or anything but text). Then reenter the formula. Or Try tools|Options|View tab|and uncheck Formulas (xl2003 menus) Trev wrote: When I entered a formula into a cell it stays visible. I have tried several different styles of format and the only change I have been able to get resulted in a #ref error. Any ideas would help. Thanks Trev -- Dave Peterson . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula stays visible in cell
Look on the data tab on the ribbon. You should be able to find it.
Trev wrote: I am using 2007. "Dave Peterson" wrote: Try formatting the cell as General (or anything but text). Then reenter the formula. Or Try tools|Options|View tab|and uncheck Formulas (xl2003 menus) Trev wrote: When I entered a formula into a cell it stays visible. I have tried several different styles of format and the only change I have been able to get resulted in a #ref error. Any ideas would help. Thanks Trev -- Dave Peterson . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Text not fully visible in Formula Bar | Setting up and Configuration of Excel | |||
| Formula stays in the cell | Excel Discussion (Misc queries) | |||
| formula stays same in cell when new row is inserted | Excel Worksheet Functions | |||
| Formula stays displayed in cell | Excel Worksheet Functions | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
![Trev[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
