Works: How to Invert Sign of a Range of Numbers in a Spreadsheet (93357)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
- Microsoft Works 4.5
- Microsoft Works 4.5a
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 4.0a
- Microsoft Money 2000 Business and Personal
This article was previously published under Q93357 SUMMARY
The following procedure inverts the sign of a range of numbers in the
spreadsheet module of Microsoft Works for Windows. All positive numbers will be made negative and all negative numbers positive. Note that any formulas in the selected area will be lost.
- Select the area for which the sign is to be reversed.
- From the Edit menu, click Copy.
- From the Edit menu, click Clear. This will remove the
information from the highlighted area.
- From the Edit menu, click Paste Special.
- Select Subtract Values and click OK.
The selected area will now contain the original numbers, but with the
positive numbers negative and the negative numbers positive.
REFERENCES
For more information about how to perform this task in Works for Windows
95, see your Works printed documentation or online Help.
"Microsoft Works for Windows User's Guide," version 3.0, pages 180-181
"Microsoft Works for Windows User's Guide," version 2.0, pages 121-122
Modification Type: | Major | Last Reviewed: | 11/15/2004 |
---|
Keywords: | kbinfo KB93357 |
---|
|