Converting Numbers eg. 88280 to 882.80

[Lainyb1964]

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

[#2]

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.

[#3]

@Lainyb1964 

How do you import data? It's better to make transformation within importing procedure, if possible.