Solved How Do I Remove Trailing Zeroes in Excel 2010?

It depends on whether you want to leave the new values in the original column or move them elsewhere.

To leave them in the same column, follow these steps:

1 – Select an empty cell and enter 100
2 – Copy the Cell
3 – Select your original values
4 – Right Click, choose Paste Special
5 – Check the Divide box
6 – Click OK

To have them end up someplace else, any of these methods, as well as many others, will work:

Divide by 100:

=A1/100

Use the LEFT function. Since LEFT returns a text value, multiply the result by 1 to turn it back into a number if required.

If the original value will always be 6 digits, extract the first 4:

=LEFT(A1,4)*1

If the original value will vary in length, return just the digits to the LEFT of the last 2:

=LEFT(A1,LEN(A1)-2)*1

After performing any of the “new location” methods described above, you can replace the original values as follows:

1 – Select the new values
2 – Copy
3 – Select the original values
4 – Right-click, choose Paste Special
5 – Check the box next to Values
6 – Click OK

Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

message edited by DerbyDad03