If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Why do all my calculations/formulas equal zero?
I've recently been upgraded to excel 2003 and when I open a file I'd been
working on in excel 97 any formula entered has the result '0'. Even if I go to a blank cell and type '=1+1' the answer is still 0. Any ideas anyone? 
Ads 
#2




Why do all my calculations/formulas equal zero?
format the cell where you typed =1+1 to a number with 2 decimal places and tell us what you get  robert111  robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=560602 
#3




Why do all my calculations/formulas equal zero?
Tried that just says 0.00. Also I've opened a new blank file and have the
same problems. A collegue has also created a file with a few simple sums and saved it, when I open this file the answers display correctly however if i add any new calculations the answer is zero. "robert111" wrote: > > format the cell where you typed =1+1 to a number with 2 decimal places > and tell us what you get > > >  > robert111 >  > robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 > View this thread: http://www.excelforum.com/showthread...hreadid=560602 > > 
#4




Why do all my calculations/formulas equal zero?
Is it set for Manual calculation? Check the Tools, Options, Calculation tab
Sheila www.cims.com MS Office training  London "Andy" wrote: > I've recently been upgraded to excel 2003 and when I open a file I'd been > working on in excel 97 any formula entered has the result '0'. Even if I go > to a blank cell and type '=1+1' the answer is still 0. > > Any ideas anyone? 
#5




Why do all my calculations/formulas equal zero?
It's ok now it seems to work. One of my collegues logged into my machine and
it worked for them and when I logged back in it was working again. "Andy" wrote: > Tried that just says 0.00. Also I've opened a new blank file and have the > same problems. A collegue has also created a file with a few simple sums and > saved it, when I open this file the answers display correctly however if i > add any new calculations the answer is zero. > > "robert111" wrote: > > > > > format the cell where you typed =1+1 to a number with 2 decimal places > > and tell us what you get > > > > > >  > > robert111 > >  > > robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 > > View this thread: http://www.excelforum.com/showthread...hreadid=560602 > > > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
make multiple cells in 1 worksheet equal multiple cells in another  riley454  Excel Worksheet Functions  1  January 19th 06 04:00 PM 
How do I get an automatic equal sign to begin the formula bar?  scarlette belle  New Users to Excel  1  January 6th 06 12:07 AM 
EQUAL SIGN  K Nguyen  Excel Discussion (Misc queries)  2  December 15th 05 08:30 PM 
Formula which is greater tahn or equal to zero  bruce2444  Excel Worksheet Functions  2  September 7th 05 12:24 PM 
Addition to Turn cell red if today is greater or equal to date in cell  Rich  New Users to Excel  2  December 9th 04 03:06 AM 