shoagun
December 1st, 2006, 07:37 AM
Hi,
does anyone know how to control openoffice calc? oo seems to insist on having the number of decimal places set. Say I want to enter the numbers
0.5
0.55
0.555
oo defaults to two decimal places, and it formats the cells to be
0.50
0.55
0.56
If I set it to three decimal places, I get
0.500
0.550
0.555
But, I want it to only print exactly what I write! Anyone know how to do this? As a second question, does anyone know how to change the default cell formatting? So that I don't have to play with it every time I start a new spreadsheet?
Alternatively, is there a better spreadsheet program out there? One that lets you do what you want, instead of forcing you to do what it thinks you want?
does anyone know how to control openoffice calc? oo seems to insist on having the number of decimal places set. Say I want to enter the numbers
0.5
0.55
0.555
oo defaults to two decimal places, and it formats the cells to be
0.50
0.55
0.56
If I set it to three decimal places, I get
0.500
0.550
0.555
But, I want it to only print exactly what I write! Anyone know how to do this? As a second question, does anyone know how to change the default cell formatting? So that I don't have to play with it every time I start a new spreadsheet?
Alternatively, is there a better spreadsheet program out there? One that lets you do what you want, instead of forcing you to do what it thinks you want?