Change negative numbers to positive and vice versa

Number & Date > Change negative numbers to positive and vice versa...

With this utility you can change positive numbers to negative and negative numbers to positive.

You can also make all the numbers in the highlighted cells negative or positive.

You can choose from:

• Change positive numbers to negative and vice versa;
• Make all numbers positive;
• Make all numbers negative.

This can be useful, for example, if you have a balance with debit and credit figures.

Screenshot

After application:

Launch this tool

Click YLC Utilities > Number & Date > Change negative numbers to positive and vice versa... :

Do you recognize any of these situations?

• How to convert all numbers in one column to negative in LO Calc without manually putting a minus sign in front of each number?
• I tried using the replace function, but I couldn't figure out how to easily change a positive amount to a negative amount...
• How in LO Calc can I automatically change all negative numbers in 4 columns to positive numbers? I don't want to manually change all these numbers as it's a very long list!
• How to convert numbers to the opposite sign? I need to change all positive numbers in the spreadsheet to negative numbers and vice versa in LO Calc.
• I would like to change the sign (from (-) to (+) and from (+) to (-)) in my data. I would like to change the sign in columns C, D and I. Any idea how to do this?

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .