Ok, the formula looks OK. So for the next step, I would do the following: Enter the following in L45: =J45
Then fill down about 10 rows, so that L46 contains "=J46" and so on until L54 contains "=J54" (without the quotes of course). Is the numbers in the L column identical with those in the J column? If not, something is wrong in the J column. Then correct the problem and look for more corrupted cells. The problem could be the format of some of the cells in the J column, as someone suggested, or it can be something else I guess. This is what I would do anyway. J.R. 2007/9/16, musomba <[EMAIL PROTECTED]>: > > Tried Shift+Ctrl+F9. No change. > > http://www.ezziarts.com/calc03.jpg > > > "Johnny Rosenberg" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > F9 does not recalculate everything, try Shift+Ctrl+F9. > > > > However, I would like to see a screenshot of the file in Calc when K49 > is > > highlighted, so I can see it's formula. > > > > J.R. > > > > 2007/9/15, musomba <[EMAIL PROTECTED]>: > > > > > > Thanks you so much for your quick response. It is encouraging that > your > > > computer opens up this document correctly. > > > > > > In order to try and solve the problem i downloaded and installed open > > > office > > > (version 2.2.1) on my laptop so the screen caps are from my computer. > Both > > > my boss and myself have this problem when opening mullah.xls with open > > > office. > > > > > > The hidden column is for chipped panels. Its hidden because the data > is > > > not > > > important. I have updated mullah.xls so this column is now visible. > The > > > problem remains even after unhiding column I and starts as early as > cell > > > K49 > > > > > > I have had a look at the recalculation issue. It is set for auto > > > recalculation. Pressing F9 does not make the problem go away. See > > > http://www.ezziarts.com/calc02.jpg > > > > > > > > > > > > > > > > > > "Adrian Try" <[EMAIL PROTECTED]> wrote in message > > > news:[EMAIL PROTECTED] > > > > Hi Musomba > > > > > > > > > When opened in calc, the 'balance owed' column gets all jumbled > up. > > > see > > > > > screen cap here:- > > > > > I and every one else at work uses excel, My Boss has begun to use > open > > > > > office on his laptop and wants me to solve this problem. he does > not > > > > > believe > > > > > its an open office problem. > > > > > > > > I agree with your boss - it's not a problem with OpenOffice. When I > open > > > > the spreadsheet with OpenOffice, I get the same results as your > Excel > > > > screenshot. > > > > > > > > The question is: Why is your boss's Calc giving different results? > The > > > key > > > > seems to be the formula in K54. > > > > > > > > Is the spreadsheet that your boss is opening the same spreadsheet > that > > > > everyone else is opening, or a copy that may have been > modified? The > > > > formula refers to cell I54. Column I is hidden. Is it possible that > > > there > > > > is a value entered there? > > > > > > > > Or is it possible that he has turned recalculation off? Check the > Tools > > > / > > > > Cell Contents menu section. > > > > > > > > Adrian > > > > > > > > > > > > -- > > > > Using Opera's revolutionary e-mail client: > http://www.opera.com/mail/ > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
