fomatting currency

P

Pammy

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?
 
F

FSt1

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

Regards
FSt1
 
R

RagDyer

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.
 
Top