Page 166 - JoFA_2022

TECHNOLOGY Q&A

Change positive numbers to negative ones contents of Excel into Word and PowerPoint,
Converting a positive number into a negative it will not update the Excel contents with
number is done much the same way as a percentage Excel capabilities. Paste Special can be used to
increase. You can use Paste Special to multiply the paste Excel cells, tables, and worksheets into
positive number(s) by -1. Enter -1 into a blank cell Word and PowerPoint while retaining Excel
and copy that cell. Then select the cells that need capabilities.
to be converted to a negative number and choose To do so, copy the Excel cells, table, or work-
Paste Special from the Home tab. Select Multiply sheet. In the Word or PowerPoint document,
and click OK. place the cursor where you would like the Excel
contents pasted and choose Paste Special. Select
Pasting into Word and PowerPoint Microsoft Excel Worksheet Object and click
Although a simple copy and paste can copy the OK. See the screenshot below.

34 | Journal of Accountancy April 2022