I have a file that was brought into excel in one column, example 5146900. It
is money that should be $51,469.00. When I go to format this as currency it
adds two decimals at the end $5,146,900.00, I want it fomatted as $51,459.00.
How do I get it to use the last two numbers as the cents?