On Friday 14 September 2007, musomba wrote: > Greetings everybody. > > The spreadsheet is here > > http://www.ezziarts.com/mullah.xls > > When opened in excel, the 'balance owed' column data ascends nice and > correctly, see screen cap here:- > > http://www.ezziarts.com/excel.jpg > > When opened in calc, the 'balance owed' column gets all jumbled up. see > screen cap here:- > > http://www.ezziarts.com/calc.jpg > > > 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. > > Please help!
When numbers are formatted as text, they cannot be used in calculations or formulas. Take a hard look at column J (starting with J49). What format is the cell (right click, format cells, look at the number tab)? If you search the help file for "formats;changing text/number", you will find instructions on how to fix this. The trickiest part is resetting the cell formats to non-text. The fastest way I know of to do this is to select the cells you want to make non-text then go Format -> Default Formatting. This will reset the all the cell formats, including font, borders, alignment, color, etc. These are easy to reset (perhaps it's time to create a cell style) compared to selecting each cell individually and changing the format to non-text. -- Fail to learn history-repeat it. Fail to learn rights-lose them. Learn both-get screwed by previous two groups. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
