Converting #s to specified #digits
Hi! Any help is appreciated.
I have two columns of data that represent dollar amounts. The amounts vary
across the board. Is there a formula that I could put in that would take the
numbers and change them all to be represented in a single dollar amount?
For example, if I want to represent everything in millions (Mk),
7,240,000 would be displayed as 7.2; 125,000 would be displayed as .1
I would also like to make sure it is rounding the tenths places, so that if
the first example had been 7,280,000, it would display as 7.3
If there's not a formula that can do this, could you also let me know.
Thanks!
|