Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas coming up as text
Formulas continue to appear as text and will not calculate. how to get
formulas to always calculate. |
#2
|
|||
|
|||
If your formulas appear as text, then you need to first clear the cells
before entering formulas. Select the cells, hit Edit--Clear--All. Save the file, format the column as General, and try again. ******************* ~Anne Troy www.OfficeArticles.com "cheryl" wrote in message ... Formulas continue to appear as text and will not calculate. how to get formulas to always calculate. |
#3
|
|||
|
|||
Cheryl,
One possibility is that Tools - Options - View - Formulas has been set. This causes columns to widen, and all formulas to appear as formulas, not the results in the usual way. Pressing Ctrl ` (the ` character is one key left of the 1 key) toggles this setting on and off, and could have been pressed by accident. -- Earl Kiosterud www.smokeylake.com "cheryl" wrote in message ... Formulas continue to appear as text and will not calculate. how to get formulas to always calculate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding text in formulas | Excel Worksheet Functions | |||
show text after formulas | Excel Discussion (Misc queries) | |||
HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? | Excel Worksheet Functions | |||
Excel formulas to create large blocks of text | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |