Forum Discussion

Lainyb1964's avatar
Lainyb1964
Copper Contributor
Jul 09, 2020

Converting Numbers eg. 88280 to 882.80

Hi just wondering if anyone can give me a quick way of converting columns of figures. My figures have been imported to excel as e.g. 88280 but it should actually read 882.80, 

 

Thanks

 

excel

2 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 09, 2020
    add a column to divide by 100. so if data is in col A then in col B (starting at B1) =A1/100 If you don't want to keep that you can copy col B and paste as VALUES back on Col A and delete Col B. But I encourage keeping all original data.

Resources