Excel does not calculate my formulas - microsoft.public.excel.misc

This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just return a zero value. I made sure of the following: - Cell is set to General (tried it with different cell settings too) - Autocalc is on in settings (even a manual F9 calc doesn't work) -- Martin Verville

We might need a few more clues: What is in A1? What is in A2? -- David Biddulph "Martin" <Martin@discussions.microsoft.com> wrote in message news:A9A25385-5BE8-4D38-A7A7-15E523C69DD9@microsoft.com... > This is very strange...Excel does not calculate any formula. I can do a > simple =A1+A2, and it just return a zero value. > > I made sure of the following: > - Cell is set to General (tried it with different cell settings too) > - Autocalc is on in settings (even a manual F9 calc doesn't work) > > -- > Martin Verville

Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero onstead of tree. I've tried with a couple different excel file in the company and i'm at the same point, always the same problem. -- Martin Verville "David Biddulph" wrote: > We might need a few more clues: > What is in A1? What is in A2? > -- > David Biddulph > > "Martin" <Martin@discussions.microsoft.com> wrote in message > news:A9A25385-5BE8-4D38-A7A7-15E523C69DD9@microsoft.com... > > This is very strange...Excel does not calculate any formula. I can do a > > simple =A1+A2, and it just return a zero value. > > > > I made sure of the following: > > - Cell is set to General (tried it with different cell settings too) > > - Autocalc is on in settings (even a manual F9 calc doesn't work) > > > > -- > > Martin Verville > > > . >

Sounds like your numbers are Text. Format to General or Number then copy an empty cell. Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. Gord Dibben MS Excel MVP On Thu, 4 Feb 2010 11:22:01 -0800, Martin <Martin@discussions.microsoft.com> wrote: >Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero >onstead of tree. > >I've tried with a couple different excel file in the company and i'm at the >same point, always the same problem.

sorry, I forgot to told you that I have tried this too, i'm stuck with my problem maybe unistall and reinstall Ofiice will set the problem ? -- Martin Verville "Gord Dibben" wrote: > Sounds like your numbers are Text. > > Format to General or Number then copy an empty cell. > > Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. > > > Gord Dibben MS Excel MVP > > On Thu, 4 Feb 2010 11:22:01 -0800, Martin <Martin@discussions.microsoft.com> > wrote: > > >Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero > >onstead of tree. > > > >I've tried with a couple different excel file in the company and i'm at the > >same point, always the same problem. > > . >

Try this first... Confirm your calculation setting. Create a new workbook. Add a simple formula to the new book such as the one you have. If it calc's correctly then it is not XL but a problem in the workbook. If the cells were previously text and you just reformatted them to number then the underlying value will still be Text. You need to force XL to convert them. Gord posted a method to do that. -- HTH... Jim Thomlinson "Martin" wrote: > sorry, I forgot to told you that I have tried this too, i'm stuck with my > problem maybe unistall and reinstall Ofiice will set the problem ? > -- > Martin Verville > > > "Gord Dibben" wrote: > > > Sounds like your numbers are Text. > > > > Format to General or Number then copy an empty cell. > > > > Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. > > > > > > Gord Dibben MS Excel MVP > > > > On Thu, 4 Feb 2010 11:22:01 -0800, Martin <Martin@discussions.microsoft.com> > > wrote: > > > > >Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero > > >onstead of tree. > > > > > >I've tried with a couple different excel file in the company and i'm at the > > >same point, always the same problem. > > > > . > >

And of course if there is any doubt as to whether the contents are text, ISNUMBER() and ISTEXT() will give a clue. -- David Biddulph "Jim Thomlinson" <James_Thomlinson@owfg-Re-Move-This-.com> wrote in message news:94610521-A33C-41EF-9638-BC05D5A80F5F@microsoft.com... > Try this first... > Confirm your calculation setting. > Create a new workbook. > Add a simple formula to the new book such as the one you have. If it > calc's > correctly then it is not XL but a problem in the workbook. > > If the cells were previously text and you just reformatted them to number > then the underlying value will still be Text. You need to force XL to > convert > them. Gord posted a method to do that. > -- > HTH... > > Jim Thomlinson > > > "Martin" wrote: > >> sorry, I forgot to told you that I have tried this too, i'm stuck with my >> problem maybe unistall and reinstall Ofiice will set the problem ? >> -- >> Martin Verville >> >> >> "Gord Dibben" wrote: >> >> > Sounds like your numbers are Text. >> > >> > Format to General or Number then copy an empty cell. >> > >> > Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. >> > >> > >> > Gord Dibben MS Excel MVP >> > >> > On Thu, 4 Feb 2010 11:22:01 -0800, Martin >> > <Martin@discussions.microsoft.com> >> > wrote: >> > >> > >Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return >> > >zero >> > >onstead of tree. >> > > >> > >I've tried with a couple different excel file in the company and i'm >> > >at the >> > >same point, always the same problem. >> > >> > . >> >

On Thu, 04 Feb 2010 12:12:51 -0800, Gord Dibben <gorddibbATshawDOTca> wrote: >Sounds like your numbers are Text. > >Format to General or Number then copy an empty cell. > >Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. > > >Gord Dibben MS Excel MVP > Do the older versions work differently, Gord? In 2007, if I, with a new workbook Format Column A as TEXT A1: 1 A2: 2 B1: =A1+A2 --> 3 The same occurs if I enter '1 and '2 in cells pre-formatted as General. --ron

Ron Tested in my 2007 with new workbook. Format A1:A2 as Text A1 1 A2 2 A3 =A1+A2 results in 0 Same for '1 and '2 Gord On Fri, 05 Feb 2010 07:03:01 -0500, Ron Rosenfeld <ronrosenfeld@nospam.org> wrote: >On Thu, 04 Feb 2010 12:12:51 -0800, Gord Dibben <gorddibbATshawDOTca> wrote: > >>Sounds like your numbers are Text. >> >>Format to General or Number then copy an empty cell. >> >>Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. >> >> >>Gord Dibben MS Excel MVP >> > >Do the older versions work differently, Gord? > >In 2007, if I, with a new workbook > Format Column A as TEXT > A1: 1 > A2: 2 > B1: =A1+A2 > --> 3 > >The same occurs if I enter '1 and '2 in cells pre-formatted as General. > >--ron

On Fri, 05 Feb 2010 09:30:00 -0800, Gord Dibben <gorddibbATshawDOTca> wrote: >Ron > >Tested in my 2007 with new workbook. > >Format A1:A2 as Text > >A1 1 >A2 2 > >A3 =A1+A2 results in 0 > >Same for '1 and '2 > > >Gord Interesting. I just did it again, but this time on a different computer. Same results as I posted initially. Computer 1 is running W7x64; computer 2 is running XP SP3 (32 bit) XL version on computer 2 is Excel 2007 (12.0.6514.5000) SP2 MSO (12.0.6425.1000) I assume the version on my W7 machine is the same, but it's now a few hundred miles away, so I can't be sure. The other interesting phenomenon, that does occur on both machines, is that AFTER I enter =a1+a2 and see "3" as a result (without the quotes) the "3" is left justified the cell is formatted as TEXT =ISTEXT(B1) --> FALSE =ISNUMBER(B1) --> TRUE Selecting B1, then EDIT (F2) and <enter> displays just the formula, as one would expect in a text formatted cell. Very weird. But it's occurring on two different machines, two different OS's, same Excel 2007. --ron

OK. A1 & A2 formatted as text or preceded by apostrophe. In A3 =A1+A2 returns 3 =SUM(A1,A2) returns 0 which it should if A1 and A2 are text. In both cases =ISNUMBER(A1) and A2 and A3 returns FALSE, FALSE, TRUE I give up<g> Gord On Fri, 05 Feb 2010 20:50:17 -0500, Ron Rosenfeld <ronrosenfeld@nospam.org> wrote: >On Fri, 05 Feb 2010 09:30:00 -0800, Gord Dibben <gorddibbATshawDOTca> wrote: > >>Ron >> >>Tested in my 2007 with new workbook. >> >>Format A1:A2 as Text >> >>A1 1 >>A2 2 >> >>A3 =A1+A2 results in 0 >> >>Same for '1 and '2 >> >> >>Gord > >Interesting. > >I just did it again, but this time on a different computer. > >Same results as I posted initially. > >Computer 1 is running W7x64; computer 2 is running XP SP3 (32 bit) > >XL version on computer 2 is Excel 2007 (12.0.6514.5000) SP2 MSO >(12.0.6425.1000) > >I assume the version on my W7 machine is the same, but it's now a few hundred >miles away, so I can't be sure. > >The other interesting phenomenon, that does occur on both machines, is that >AFTER I enter =a1+a2 and see "3" as a result (without the quotes) > the "3" is left justified > the cell is formatted as TEXT > =ISTEXT(B1) --> FALSE > =ISNUMBER(B1) --> TRUE > Selecting B1, then EDIT (F2) and <enter> displays just the formula, as >one would expect in a text formatted cell. > >Very weird. But it's occurring on two different machines, two different OS's, >same Excel 2007. > >--ron

On Sat, 06 Feb 2010 08:05:47 -0800, Gord Dibben <gorddibbATshawDOTca> wrote: >OK. > >A1 & A2 formatted as text or preceded by apostrophe. > >In A3 =A1+A2 returns 3 > >=SUM(A1,A2) returns 0 which it should if A1 and A2 are text. > >In both cases =ISNUMBER(A1) and A2 and A3 returns > >FALSE, FALSE, TRUE > >I give up<g> > > >Gord So we do both have Excel's that work alike. (I agree that SUM(a1,a2)--> 0 and the =a1+a2 --> 3) And yet, the OP's does not, apparently. Unless there is something he has omitted. --ron

check your options. Auto Calc maybe switch off Tools > Options > Calcualtion Tab then click Auto Calc Martin wrote: Excel does not calculate my formulas 04-Feb-10 This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just return a zero value. I made sure of the following: - Cell is set to General (tried it with different cell settings too) - Autocalc is on in settings (even a manual F9 calc does not work) -- Martin Verville Previous Posts In This Thread: On Thursday, February 04, 2010 1:17 PM Martin wrote: Excel does not calculate my formulas This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just return a zero value. I made sure of the following: - Cell is set to General (tried it with different cell settings too) - Autocalc is on in settings (even a manual F9 calc does not work) -- Martin Verville On Thursday, February 04, 2010 1:29 PM David Biddulph wrote: We might need a few more clues:What is in A1? What is in A2?--David Biddulph We might need a few more clues: What is in A1? What is in A2? -- David Biddulph On Thursday, February 04, 2010 2:22 PM Martin wrote: Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zeroonstead Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero onstead of tree. I have tried with a couple different excel file in the company and i'm at the same point, always the same problem. -- Martin Verville "David Biddulph" wrote: On Thursday, February 04, 2010 3:12 PM Gord Dibben wrote: Sounds like your numbers are Text. Sounds like your numbers are Text. Format to General or Number then copy an empty cell. Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc. Gord Dibben MS Excel MVP wrote: On Thursday, February 04, 2010 3:53 PM Martin wrote: sorry, I forgot to told you that I have tried this too, i'm stuck with sorry, I forgot to told you that I have tried this too, i'm stuck with my problem maybe unistall and reinstall Ofiice will set the problem ? -- Martin Verville "Gord Dibben" wrote: On Thursday, February 04, 2010 5:06 PM Jim Thomlinson wrote: Try this first...Confirm your calculation setting.Create a new workbook. Try this first... Confirm your calculation setting. Create a new workbook. Add a simple formula to the new book such as the one you have. If it calc's correctly then it is not XL but a problem in the workbook. If the cells were previously text and you just reformatted them to number then the underlying value will still be Text. You need to force XL to convert them. Gord posted a method to do that. -- HTH... Jim Thomlinson "Martin" wrote: On Friday, February 05, 2010 6:00 AM David Biddulph wrote: And of course if there is any doubt as to whether the contents are And of course if there is any doubt as to whether the contents are text, ISNUMBER() and ISTEXT() will give a clue. -- David Biddulph On Friday, February 05, 2010 7:03 AM Ron Rosenfeld wrote: Do the older versions work differently, Gord? Do the older versions work differently, Gord? In 2007, if I, with a new workbook Format Column A as TEXT A1: 1 A2: 2 B1: =A1+A2 --> 3 The same occurs if I enter '1 and '2 in cells pre-formatted as General. --ron On Friday, February 05, 2010 12:30 PM Gord Dibben wrote: RonTested in my 2007 with new workbook. Ron Tested in my 2007 with new workbook. Format A1:A2 as Text A1 1 A2 2 A3 =A1+A2 results in 0 Same for '1 and '2 Gord wrote: On Friday, February 05, 2010 8:50 PM Ron Rosenfeld wrote: Interesting.I just did it again, but this time on a different computer. Interesting. I just did it again, but this time on a different computer. Same results as I posted initially. Computer 1 is running W7x64; computer 2 is running XP SP3 (32 bit) XL version on computer 2 is Excel 2007 (12.0.6514.5000) SP2 MSO (12.0.6425.1000) I assume the version on my W7 machine is the same, but it is now a few hundred miles away, so I cannot be sure. The other interesting phenomenon, that does occur on both machines, is that AFTER I enter =a1+a2 and see "3" as a result (without the quotes) the "3" is left justified the cell is formatted as TEXT =ISTEXT(B1) --> FALSE =ISNUMBER(B1) --> TRUE Selecting B1, then EDIT (F2) and <enter> displays just the formula, as one would expect in a text formatted cell. Very weird. But it is occurring on two different machines, two different OS's, same Excel 2007. --ron On Saturday, February 06, 2010 11:05 AM Gord Dibben wrote: OK.A1 & A2 formatted as text or preceded by apostrophe. OK. A1 & A2 formatted as text or preceded by apostrophe. In A3 =A1+A2 returns 3 =SUM(A1,A2) returns 0 which it should if A1 and A2 are text. In both cases =ISNUMBER(A1) and A2 and A3 returns FALSE, FALSE, TRUE I give up<g> Gord wrote: On Saturday, February 06, 2010 3:13 PM Ron Rosenfeld wrote: So we do both have Excel's that work alike. So we do both have Excel's that work alike. (I agree that SUM(a1,a2)--> 0 and the =a1+a2 --> 3) And yet, the OP's does not, apparently. Unless there is something he has omitted. --ron On Monday, May 10, 2010 5:25 AM Charl de Winnaar wrote: Excel does not claculate Hi Had same problem but found solution on-line Check your options. Auto Calc may be switched off Tools > Options > Calcualtion Tab then click Auto Calc. Hope this helps Submitted via EggHeadCafe - Software Developer Portal of Choice BOOK REVIEW: Effective C#, Second Edition [Addison Wesley] http://www.eggheadcafe.com/tutorials/aspnet/b2f8766d-a4c1-4d5a-97af-c38852b3b455/book-review-effective-c.aspx

Similiar Articles:

Excel does not calculate my formulas - microsoft.public.excel.misc ...
This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just return a zero value. I made sure of the follo...

excel 2007 does not automatically calculate - microsoft.public ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... want excel 2007 to stop calculating processors - microsoft.public ... stop automatic rounding ...

F9 Calc refresh does not work... - microsoft.public.excel.misc ...
I have a spreadsheet which has some formulas which do not refresh properly. They are simple "IF" formulas. If I press F9 or Options / Calculate ...

Do not calculate or update formula's during macro - microsoft ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... This is very strange...Excel does not calculate any formula. I can do a simple ... macro to ...

if statement to DISPLAY (not calculate) a formula? - microsoft ...
Excel viewer does not display formula values - microsoft.public ... if statement to DISPLAY (not calculate) a formula? - microsoft ... Excel does not calculate my formulas ...

Calculating(Processors(2)): % - microsoft.public.excel.programming ...
While waiting for an expert response, I'll entertain you with my random babbling :) 1. It appears that in the latter part of your macro you are adding formulas ...

macro to calculate or make/update formula - microsoft.public.excel ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... macro to calculate or make/update formula - microsoft.public.excel ... Excel does not calculate my ...

Calculate Selected Cells Only? - microsoft.public.excel.misc ...
I have a heavy excel workbook with lots of formulas, every time I did something it was calculating literally for 20mins, so I changed it to Manual ...

Manual Calculation in Excel 2007 with Calculate mode set to ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... Manual Calculation in Excel 2007 with Calculate mode set to ... Excel ... want excel 2007 to stop ...

Sumproduct with Conditions for weighted avearge calculation ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... Excel does not calculate my formulas - microsoft.public.excel.misc ... Sumproduct with Conditions ...

calculate 6 months forward from a date - microsoft.public.excel ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... What is the formula for calculating the age (Expiry Date ... Excel does not calculate my formulas ...

How do I set up a weighted formula in Excel? - microsoft.public ...
Try setting the calculation to ... Ho do I shift empty cells up in ... The formula does its job well ... is very strange...Excel does not calculate any formula.

How do I ensure formulas automatically calculate after pasting ...
I have just recently installed Excel 2003. When I copy and paste a formula into a column the result of the first cell copies down the column and I ...

test posting calculations formula tab - microsoft.public.excel ...
Make sure calculation is set to automatic: In Excel 2007: Formulas tab>Calculation ... ... Wanting a formula to calculate a persons age from birth ... will do age Put your ...

formula showing in cell rather than answer for formula - microsoft ...
calculate 6 months forward from a date - microsoft.public.excel ... Excel does not calculate my formulas - microsoft.public.excel.misc ... formula showing in cell rather ...

want excel 2007 to stop calculating processors - microsoft.public ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... want excel 2007 to stop calculating processors - microsoft.public ... stop automatic rounding ...

Need formula to calculate bi-monthly pay dates - microsoft.public ...
Calculating dates to include Saturdays but not Sundays - microsoft ... Need formula to calculate bi-monthly pay dates - microsoft.public ... Excel does not ...

Excel Formula - microsoft.public.excel.worksheet.functions ...
Excel does not calculate my formulas - microsoft.public.excel.misc ... This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just ...

Calculate the Circumference of an ellipse - microsoft.public.excel ...
Is there a formula to Calculate the Circumference of an ellipse in excel? ... ... There is not a standard formula for this. Someone may know of one available as a ...

Excel F2 not working... - microsoft.public.excel.worksheet ...
F2 works perfectly in Excel 2007. It opens the cell for editing and in doing so, highlights any other cells referenced in a formula in the active cell with colored ...

What do I do when My Excel Formula Does Not Calculate? | Excel ...
After spending hours putting together your spreadsheet, entering all of the data and putting together the various formulas you are going to use to calculate your ...

Excel does not calculate my formulas - Microsoft Answers
This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just return a zero value. I made sure of the following: - Cell is set to ...

Excel does not calculate formulas automatically. ¿? - Yahoo! Answers
Best Answer: if the cell is specifically formatted to be "text", then that can happen. Go to "Format", "Cell", then change the format to "General" I just ...

[SOLVED] formula does not calculate - Excel Help Forum
Help! Something is weird with my Excel sheet. When I enter a formula, for example =AB2+AB3 Excel does not calculate the result. Instead the formula just stays as it ...

Why Does a Cell Not Calculate in Excel? | eHow.com
Trying to figure out why your formula won't calculate in Microsoft Excel can be difficult. It could be a formula error, a formatting error or a circular reference ...

Excel does not calculate my formulas - ExcelBanter
Excel Discussion (Misc queries) ... This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2 ... We might need a few more clues: What is ...

Excel - Formula Does Not Calculate - Help Something... - Free ...
Formula Does Not Calculate - Help Something is weird with my Excel sheet When I enter... - Free Excel Help

Excel - Why Have My Spreadsheets Stopped Calculating Formulas ...
Why Have My Spreadsheets Stopped Calculating Formulas? - The sheet calculates only those cells that I retype... - Free Excel Help

Reasons Why Formulas Are Not Calculating in Microsoft Excel | eHow.com
Microsoft Excel is a spreadsheet software program that is part of Microsoft’s Office productivity software package. Excel comes in several different versions such ...

7/27/2012 5:07:34 PM