fomatting currency

  • Thread starter Thread starter Pammy
  • Start date Start date
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?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format cell - Miles 5
Cell Format on Imported Data 3
Mail Merge Formating Issues 3
Number Formatting in a concatenated cell 3
Number Format question 3
Formatting Currency Without Any Special Characters 3
conditional formatting 3
Dollar amounts aren't merging from Excel into a Word document... 3

Back
Top