Forum Discussion
Solved
formatting cells to eliminate decimals
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 ...
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.
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.