SOLVED

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.

thanks

alisa_majer_0-1662370067936.png

 

1 Reply
best response confirmed by alisa_majer (Occasional Visitor)
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.