Forum Discussion
dabhanddaz
Aug 24, 2022Copper Contributor
Excel rounding numbers
Hi, Wondering if anyone can help, I can not stop excel rounding up/down numbers, I have formatted cells to 0 decimal polaces, tried the "decrease decimal" on home tab, tried custom and special f...
Aug 24, 2022
Hi dabhanddaz
It could be due to the width of the column, the number is big to be display in the cell so excel round it.
try to increase the width of the cell.
- dabhanddazAug 24, 2022Copper Contributor
Thanks but no, I have tried all solutions avaiable by goggle/youtube etc... , I have tried copy and paste as plain text but can not stop the rounding
- dabhanddazAug 24, 2022Copper ContributorOh and maybe helpful, the number is from an excel formula