** Reply to message from James Hatridge <James.Hatridge@epost.de> on Tue, 31 Aug 2004 12:25:54 +0200

I have in a speadsheet a number for example "1.23", but it is actually "1.299999995". When I save this to a csv file I want the 1.23, but I get the !"§§!"§ 1.29999995. How can I tell Oo to save the short form?

If is the result of a sum, for instance, use =ROUND(SUM(A1:A3);2 and it will not only display 1.30, but also contain the true value of 1.30. Ed Harrison SuSE 9.1, Kernel 2.6.7-vanilla PolarBar Mailer 1.25a

James Hatridge wrote:

Hi all...

I have in a speadsheet a number for example "1.23", but it is actually "1.299999995". When I save this to a csv file I want the 1.23, but I get the !"§§!"§ 1.29999995. How can I tell Oo to save the short form?

Thanks,

JIM Jim,

You need to set the number of decimal places in the cell by selecting the cell/s, Clicking on Format:Cells and specifying the number of decimal places you want in that cell. Happy to help -- The Little Helper ======================================================================== Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user ========================================================================