Hi :) Ok, so you have been trying Format - Cells - Numbers - Currency but how about just using a 2nd sheet or column to do calculations and just divide by 100? Regards from Tom :)
________________________________ From: John D <[email protected]> To: [email protected] Sent: Wed, 17 August, 2011 7:25:51 Subject: [libreoffice-users] Decimal Point Move Can anyone help with Calc. Move Decimal Point from the following: The result in a the cell is 1.23 of which I would like to format the cell to 0.0123 >From 1.23 To 0.0123 I have tried numerous formats including 0.##"00" but to no avail. How do I move the decimal point in front of the figure 1? John D -- View this message in context: http://nabble.documentfoundation.org/Decimal-Point-Move-tp3260784p3260784.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
