Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
last ten digits | Excel Worksheet Functions | |||
16 digits | Excel Discussion (Misc queries) | |||
Converting Dates to 8 digits | Excel Worksheet Functions | |||
2 DIGITS OUT OF 4 | Excel Discussion (Misc queries) | |||
2 DIGITS OUT OF 4 | Excel Discussion (Misc queries) |