hi
one way.
in a cell off to the side, enter .01. copy it. highlight the column.
then editpastespecialmultiply. format as currency.

Regards
FSt1

"Pammy" wrote:

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?