On 01/19/2016 09:09 AM, Spencer Graves wrote: > > > On 1/19/2016 7:55 AM, Alek wrote: >> A calc sheet I've made has thousands of 4 place decimal numbers that >> never go over .9999 (it's a cosine trig. figure) >> >> The decimal place takes up space on the sheet(s) and isn't needed as the >> sheet will be printed out as a PDF. >> >> Can someone please tell me how to get rid of the decimal point and so >> that the resulting number doesn't change? > > > Multiply by 10000 then display as integer? > That's perfect.
Thanks, Alek > > You can do this in an extra display column beside the column > with the number you want to display, then Format > Column > Hide the > column with the number you want to display. This is not as > emotionally satisfying as doing it with a special format code, but I > don't know the latter, and this will work. Hope this helps. Spencer > Graves >> >> Alek >> >> > > -- To unsubscribe 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
