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 <jjdowney@hotmail.com> To: users@global.libreoffice.org 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: users+help@global.libreoffice.org 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: users+help@global.libreoffice.org 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