Re: [users] Strange calc behavior? ... maybe??

[Joe Conner]

You had formatted the cell as TEXT prior to entering the number.  Thus, the number was interpreted as a string of text characters, rather than a true number. That is why the apostrophe shows up if you later change the format to NUMBER.  The cell content had already been a string of characters (of numbers) so Calc is merely trying to preserve what you had already inadvertently put in the cell.  The fact that you did not mean to enter a string of characters is beside the point.  Format the cells first to avoid this confusion in the future. Joe [EMAIL PROTECTED] wrote: I do see that, and thank you. However when I highlite the cell, and go to format/cell/number/general (or use the 1234.56 - or set decimals)the apostrophe text indicator stays in place ... so it doesn't work... but if I retype the number AFTER setting the correct format ... it will work. Another thing - maybe related... the foramt painter doesn't seem to work any better... Do I have a bad install? Mike ==================================== ==================================== When I looked at both sheets I found that you, for the most part, have defined the cells in column E as text. I think you want these to be in number format. -- Thursday, March 16, 2006, 11:36:06 AM, you wrote: Mike Masse wrote: HI all, Just installed OO and am really intrigued. However, when I opened my usual excel sheet in calc the formulas do not seem to work correctly.... I have poked through the FAQ, and didn't come up with an answer ... the formulas? They are there ... and the format seems correct (; instead of ,) etc. It might be a setting or something like that.... Col A has .55 Col B gets an entry like $10,00 (formatted for currency) Col C has a formula =A1*B1 and returns $0.00 I seem to have many (all) formulas that are not working as they should .... is that possible? WHere should I look to start correcting this? TIA Mike Works for me. I cannot recreate the problem. Is Tools >> Cell Contents > AutoCalculate turned off (unchecked)? It is checked What happens if you press F9? Nothing

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]