Simple Request

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have copied figures across from a retail report and in the excel sheet they are displayed as hundreds, as they are in the retail report. In the retail report however it is stated that they the figures represent millions. Is there any way in the excel sheet that I can convert all the figures to millions without changing every figure

Thanks
 
If I have understood you correctly, here's one
way to do it:

1. Enter 1000000 in an empty cell
2. Copy the cell
3. Select the cells to be converted
4. Choose Edit > Paste special
5. Choose "Multiply". OK
6. Press <Esc> to cancel the copy operation.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

SP said:
I have copied figures across from a retail report and in the excel sheet
Click to expand...
they are displayed as hundreds, as they are in the retail report. In the
retail report however it is stated that they the figures represent millions.
Is there any way in the excel sheet that I can convert all the figures to
millions without changing every figure?
 
SP said:
I have copied figures across from a retail report and in the excel sheet
Click to expand...
they are displayed as hundreds, as they are in the retail report. In the
retail report however it is stated that they the figures represent millions.
Is there any way in the excel sheet that I can convert all the figures to
millions without changing every figure?
Thanks
Click to expand...

Do you mean that you want to convert a figure of, say, 123 into 123000000 ?
If so, put 1000000 in a spare cell somewhere and copy it. Select the entire
range of numbers you want to convert and use
Edit > Paste Special > Operation Add > OK.
(You can now delete the 1000000 in the 'spare cell'.)
 
Paul said:
they are displayed as hundreds, as they are in the retail report. In the
retail report however it is stated that they the figures represent millions.
Is there any way in the excel sheet that I can convert all the figures to
millions without changing every figure?

Do you mean that you want to convert a figure of, say, 123 into 123000000 ?
If so, put 1000000 in a spare cell somewhere and copy it. Select the entire
range of numbers you want to convert and use
Edit > Paste Special > Operation Add > OK.
(You can now delete the 1000000 in the 'spare cell'.)
Click to expand...


Sorry - should have been "Operation Multiply".
 
Back
Top