| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula shows up as text in cell
When I type a formula in the formula bar, the cell displays the text of the
formula, not the result. What happened? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula shows up as text in cell
Hi
Clear that cell,reformat as "General" then retype your formula. HTH John "BK523" wrote in message ... When I type a formula in the formula bar, the cell displays the text of the formula, not the result. What happened? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula shows up as text in cell
Hi,
Ensure that the cell is not formatted as text. Go to Format Cells General. Another possibility could be that you have accidentally pressed Ctrl+~. Press that combination again to exit the formula auditing mode. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "BK523" wrote in message ... When I type a formula in the formula bar, the cell displays the text of the formula, not the result. What happened? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula shows as text | Excel Discussion (Misc queries) | |||
| formula bar shows a ' before text | Excel Discussion (Misc queries) | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
| Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
| TEXT SHOWS UP IN FORMULA BAR BUT NOT IN CELL? | Excel Discussion (Misc queries) | |||
Linear Mode
