Ahhh... Ok ... I think I can see that happening. Thanks! But for the record ... this is in a spreadsheet that works perfectly in Excel.....
Thanks again Mike -- Friday, March 17, 2006, 5:46:15 PM, you wrote: > 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]
