On Fri, 2006-03-17 at 12:51 -0600, [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.
Changing the format of the cell should never change the contents of the cell, only how it might be displayed. The leading apostrophe indicates that the cell must be considered as text even if it's in a non-text cell, just as a leading '=' in a text formatted cell forces Calc to interpret the cell contents as a formula. AFAIK you must remove the apostrophe manually to change the content to a number. > Another thing - maybe related... the foramt painter doesn't seem to work any > better... See above. > Do I have a bad install? No. > 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]
