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!

not sure if there is a way to actually format the cells to show this but you
could do the following.

insert a column and in the column put the following formula. =A1/1000000
then format...cells....number, 1 decimal. Then copy the formula down and you
should get the results you want. (The formula assumes your data starts in
cell A1.)

"Ash" wrote:

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!

Ash

Enter 1000000 in an unused cell.

Copy that cell.

Select the range of numbers and EditPaste Special(in place)DivideOKEsc.

Format to 1 decimal place.

Clear the cell with 1000000


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 12:52:25 -0800, Ash wrote:

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!

On Wed, 21 Feb 2007 12:52:25 -0800, Ash wrote:

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!

When you write "display" I think "format".

So here's a custom format which will display the contents of the cell as you
describe:

Format/Cells/Number/Custom Type: $#,##0.0,,

If the cell contains 7,280,000, it will display as $7.3

You may omit the "$" if you wish.


--ron

Hi,

Select format cell - Go to custom - Paste #.00,, in 'Type'. It works

Regards,
Nishad



"Ron Rosenfeld" wrote:

On Wed, 21 Feb 2007 12:52:25 -0800, Ash wrote:

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!

When you write "display" I think "format".

So here's a custom format which will display the contents of the cell as you
describe:

Format/Cells/Number/Custom Type: $#,##0.0,,

If the cell contains 7,280,000, it will display as $7.3

You may omit the "$" if you wish.


--ron