Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do all my calculations/formulas equal zero?
Is it set for Manual calculation? Check the Tools, Options, Calculation tab
Sheila www.c-i-m-s.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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
How do I get an automatic equal sign to begin the formula bar? | New Users to Excel | |||
EQUAL SIGN | Excel Discussion (Misc queries) | |||
Formula which is greater tahn or equal to zero | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |