Can someone please help me???
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.