formatting cells to eliminate decimals

Occasional Visitor

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.




1 Reply
best response confirmed by alisa_majer (Occasional Visitor)

@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 


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.