Excel Cost Column Is In Cents! Divide All By 100 - #shorts

I have an Excel file that has the cost column in cents so if something is 1.25 it is showing as 125 . When I change it to currency the numbers change to 125.00....

Anyone knows how to fix the issue faster than one by one. I have over 5,000 items to go through! In this short video, learn how to multiply an entire column by 0.01 to quickly convert 125 cents to 1 dollar and twenty five cents.