Re: [libreoffice-users] Calc- don't show the decimal point

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: users+unsubscribe@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