Sep 05 2022 02:27 AM
hello all
I have an issue where I do not manage to eliminate the decimals from a column.
the cells contain numbers and I have formatted it in such a way that the decimals are eliminated.
But when I click on the cell, the upper bar shows the number with decimals!
I tried formatting to General, text, decrease decimals but the decimals remain!
how can I eliminate them? because when I upload the file to SAP, the decimals appear and we do not want them.
thanks
Sep 05 2022 02:33 AM
Solution@alisa_majer Formatting just affects how the numbers are displayed. Not the underlying numbers. You need to round them, e.g. by using something like
=ROUND(A1,0)
That will round the number (up or down) depending on the decimal value. And then perhaps copy/paste values. Don't know if that's required, though.
Sep 05 2022 02:33 AM
Solution@alisa_majer Formatting just affects how the numbers are displayed. Not the underlying numbers. You need to round them, e.g. by using something like
=ROUND(A1,0)
That will round the number (up or down) depending on the decimal value. And then perhaps copy/paste values. Don't know if that's required, though.