Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Excell 2007 nor working
When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a")
etc instead of giving the result it simply shown the formula as above in the cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Excell 2007 nor working
This means the cell is text formatted. One way round this...
Select column and use Data Text to columns Finish "Mahmood" wrote: When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a") etc instead of giving the result it simply shown the formula as above in the cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Excell 2007 nor working
I don't use 2007 but in earlier versions this could mean you are in "Formula
View" or the cells were pre-formatted as Text. If the latter, Re-format to General then on each cell, F2 and ENTER. Gord Dibben MS Excel MVP On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood wrote: When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a") etc instead of giving the result it simply shown the formula as above in the cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Excell 2007 nor working
I tried to change the format of the cells but did not work. But going to
blank cell and changing their format to general before inserting formula worked. Thanks. "Gord Dibben" wrote: I don't use 2007 but in earlier versions this could mean you are in "Formula View" or the cells were pre-formatted as Text. If the latter, Re-format to General then on each cell, F2 and ENTER. Gord Dibben MS Excel MVP On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood wrote: When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a") etc instead of giving the result it simply shown the formula as above in the cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Excell 2007 nor working
Did you read all of my post?
I said you must re-enter the formulas after re-formatting. That's what F2ENTER does. Saves you re-typing the formulas. Gord Dibben MS Excel MVP On Sun, 13 Jul 2008 09:08:12 -0700, Mahmood wrote: I tried to change the format of the cells but did not work. But going to blank cell and changing their format to general before inserting formula worked. Thanks. "Gord Dibben" wrote: I don't use 2007 but in earlier versions this could mean you are in "Formula View" or the cells were pre-formatted as Text. If the latter, Re-format to General then on each cell, F2 and ENTER. Gord Dibben MS Excel MVP On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood wrote: When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a") etc instead of giving the result it simply shown the formula as above in the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas in 2007 not working in 2003 | Excel Worksheet Functions | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
Excell 2007???? | Charts and Charting in Excel | |||
Formulas stop working on all excell spreads at the same time | Excel Worksheet Functions | |||
Why would a formula stop working in an Excell spreadsheet? | Excel Worksheet Functions |