Converting Numbers eg. 88280 to 882.80

%3CLINGO-SUB%20id%3D%22lingo-sub-1511578%22%20slang%3D%22en-US%22%3EConverting%20Numbers%20eg.%2088280%20to%20882.80%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511578%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20just%20wondering%20if%20anyone%20can%20give%20me%20a%20quick%20way%20of%20converting%20columns%20of%20figures.%20My%20figures%20have%20been%20imported%20to%20excel%20as%20e.g.%2088280%20but%20it%20should%20actually%20read%20882.80%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1511578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511764%22%20slang%3D%22en-US%22%3ERE%3A%20Converting%20Numbers%20eg.%2088280%20to%20882.80%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511764%22%20slang%3D%22en-US%22%3Eadd%20a%20column%20to%20divide%20by%20100.%20so%20if%20data%20is%20in%20col%20A%20then%20in%20col%20B%20(starting%20at%20B1)%20%3DA1%2F100%20If%20you%20don't%20want%20to%20keep%20that%20you%20can%20copy%20col%20B%20and%20paste%20as%20VALUES%20back%20on%20Col%20A%20and%20delete%20Col%20B.%20But%20I%20encourage%20keeping%20all%20original%20data.%3C%2FLINGO-BODY%3E
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
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.

@Lainyb1964 

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