In this video, I demonstrate how to stop Excel from rounding numbers. In my scenario I have a list of numbers all with a different number of decimal places - some with one, others with seven or eight. If I increase the number of decimal places to stop Excel rounding I end up with trailing zeros on some values, which I don't want. If I decrease decimal places I am back with the rounding. I could apply the correct decimal place format to each value individually but this might be unrealistic with a large number of values.
A solution is to convert your values into text values using the Text to Columns feature. The numbers, once they have been converted to text will show the correct number of decimal places with no rounding and no trailing zeros. What is more, even though those numbers are now stored as text, you can still perform calculations on them as if they were numbers.
------------------------
Негізгі бет How to Get Excel Not to Round Numbers | Remove Trailing Zeros After Decimal |
Пікірлер: 14