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, 




2 Replies
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.


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