I have several tables within a calc sheet. There are many numbers in these tables that have multiple decimal places and I have removed the decimal places in the right click “Format Cells” menu, and that does round off to the nearest whole number but it only hides the fractions instead of removing them completely.
I’m hoping for an option somewhere (that I missed when looking) which rounds the numbers to whole numbers and removes the decimal places completely. I could do this manually but it could take several hours with all the fields I need to change. I need to do this because I am adding more info to each cell which reveals the decimal places no matter what I have the formatting options set to.
The formating never will change the numeric value itself.
You must use the function INT() or the ROUND() in some helper cells.
4 Likes
Test with the option:
Menu/Tools/Options/LibreOffice Calc/Calculate/General calculations - Precision as show.
Help Precision as show
I just noticed your reply with the round function, that helps a great deal!
In accordance to @Zizi64 :
Fit =iNT($‘Tab-0’.A1) into [A1] of a new empty Sheet and so on until [G5]:
00_LO-CALC_convert-to-integer-numbers_102502.ods (17.8 KB)
Ok, this rounds down instead of to the next whole number. Your answer led me to the round function which works. Thanks!
Strictly speaking, INT truncates, it doesn’t round down although the effect might be the same.
Note that there are other rounding functions available.
Nope. TRUNC() truncates, INT() rounds towards negative infinity, e.g. INT(-1.6) => -2.
2 Likes
The origine function is:
=HEX2DEC(DEC2HEX(A1,10)
only with max. 10 hex-numerals FFFF FFFF FF in LO-CALC, or 16 positive dec-numerals/signs resp. 17 negative incl. comma
the maximal number for HEX2DEC is ff ffff fffe which results to 1099511627774 with the lenght 13.