Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas become cell contents
I am experiencing a problem in Excel. When I enter a formula (any formula)
in certain cells the formula remains visible in the cell as the cell content. However if I enter the same formula in another part of the spreadsheet the formula behaves the way it is suppose to...invisible except for the results of the formula. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas become cell contents
I guess that your cell is formatted as text. Reformat the cell as General,
then re-enter the formula, either by typing it in again or by F2, enter. -- David Biddulph DJLT wrote: I am experiencing a problem in Excel. When I enter a formula (any formula) in certain cells the formula remains visible in the cell as the cell content. However if I enter the same formula in another part of the spreadsheet the formula behaves the way it is suppose to...invisible except for the results of the formula. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas become cell contents
DJLT wrote:
I am experiencing a problem in Excel. When I enter a formula (any formula) in certain cells the formula remains visible in the cell as the cell content. However if I enter the same formula in another part of the spreadsheet the formula behaves the way it is suppose to...invisible except for the results of the formula. The cell is formatted as TEXT. Change the cell format to GENERAL and re-enter the formula. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas become cell contents
Select the range where you have the proble. Right clickFormat Cellschange
that to General..ok. -- If this post helps click Yes --------------- Jacob Skaria "DJLT" wrote: I am experiencing a problem in Excel. When I enter a formula (any formula) in certain cells the formula remains visible in the cell as the cell content. However if I enter the same formula in another part of the spreadsheet the formula behaves the way it is suppose to...invisible except for the results of the formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy an Excel worksheet with formulas and clear contents. | Excel Discussion (Misc queries) | |||
Formulas to copy contents of one cell in a worksheet to another ce | Excel Discussion (Misc queries) | |||
excel command to clear contents except 2 formulas | Excel Discussion (Misc queries) | |||
Clear contents but leave formulas in Excel | New Users to Excel | |||
in formulas how can I use contents of a cell? | Excel Worksheet Functions |