I have to submit most of the
reports for financial statements in millions of dollars ($ ML) denomination. But data output
from my accounting software comes along with
its decimal values too. How do I quickly convert this into millions?
Normally most of the people I saw
will insert a column next to the output values column and enter a formula “=Output
value cell address /1000000” (of course, you have to replace the name in formula with actual references). This method is fine if you want to show the initial values too. But my stakeholders
are not interested in seeing that. So, I have to copy the
converted values and paste there again as values using paste special.
There is an alternate and quick
way, you can use Paste Special
functionality in this case. Just enter “1000000” in any
of the empty cell. Copy it and now select all your data output values. Right click, select Paste Special. Under Operation segment,
click on Divide. That’s it, you
have just converted all the output values into millions.
If you notice, there are other
operators also in Paste Special to
perform addition, subtraction & multiplication along with division. Go
ahead and use them extensively. Enjoy!!
No comments:
Post a Comment