Converting Numbers eg. 88280 to 882.80

Highlighted
Visitor

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

@Lainyb1964 

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