Formatting decimal places. No 0's

  • Thread starter Thread starter bdunk
  • Start date Start date
B

bdunk

HI Here is an easy one that I simply can't remember. I have imported a
document into Excel and one of the rows is a dollar amount with no
formatting. An example would be 560 would be $5.60. If I simply add two
decimal places it will show up as $560.00. How do I get excel to add
the decimal place without adding 0's. Another example is 50513. This
should be $505.13 not $50,513.00. Thanks for the help.

Bdunk
 
Must have come from a COBOL program!
In an empty cell type 100, select this cell and hit the Copy tool
Select the problem cell and use menu command Edit|Paste Special and check
the Divide box.
Works like a charm; now you can delete that 100 first entered.

best wishes
Bernard
 
As long as the imported information is consistent, I would
just add a column and divide every cell by 100. Then
format as a $amount.
 
Back
Top