Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
If you are entering the formula correctly as in =2+5 and you see =2+5 it
would mean one of two things. 1. You have "View Formulas" set on in that file. Hit CTRL + `(back quote) to turn off formula view. 2. The cells were pre-formatted as Text. Re-format to General then F2 and ENTER each cell. Gord Dibben Excel MVP On Mon, 13 Jun 2005 13:07:16 -0700, sthompson wrote: In excel when i type in formulas they do not calculate they just go in as text, this is just on one of the excel files all the other excel files it will figure out the formulas. So i create the most basic 2+5 then when i hit enter it just stays like that it does not calculate it out. And under the format cell the number tab i have general selected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |