Removing Zeros

[jrsmoke]

Is there any way i can highlight my whole worksheet and remove all the zeros at the end of numbers? My rounding is already set up but the zeros are at diff decimalmplaces and i want them all gone.

[BigBas]

if you mean zero's after decimal points, why not highlight the column, right click, go to format cells, number, tick down to zero places after decimal.

[jrsmoke]

I have numbers like 0.450 0.6780 0.10 i want all the digits, but no ending zeros. It cuts them off default but lets say i have a column that i tell to round to three decimals it makes 0.1234 show 0.123 which is fine but 0.120003 will show 0.120 and I want it to round three places then cut the zero showing 0.12.

[MrShorty]

Use the ? in your number format code instead of 0 (0.???). Search Excel Help for "number format codes" to get an explanation of all the number format codes available.