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?

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?

In an empty, unused cell, enter 100.

Format that cell to the currency format you wish to use.

Then, right click in the cell and choose "Copy".

Select the cells to change, and right click in that selection.

Click on "Paste Special",
Click on "Divide",
Then <OK
Then <Esc
Then clear that first cell.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pammy" wrote in message
...
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?