GOOGLETRANSLATE TRANSLITUA TRANSLITRU CLEANTEXT CLEANDIGITS GETSUBSTR GETNUMBER GETDATE GETURL CONCATIF SUMBYCELLCOLOR COUNTBYCELLCOLOR SUMBYFONTCOLOR COUNTBYFONTCOLOR GETCOMMENT GETSEX GETWORD WORKBOOK SHEETNAME TABLETOARRAY TABLETODICT TABLETOCSV TABLETOSQL TABLETOHTML TABLETOJSON TABLETOXML WORKHOURS ISOCOUNTRY

- UPPER REGISTER
- lower case
- With a capital letter
- Words with capital letters
- The first character is capitalized
- Other variants of registers
- Delete all letters
- Delete all numbers
- Remove trailing spaces
- Remove extra spaces
- Remove leading characters
- Remove trailing characters
- Delete text after a certain number of characters
- Get the word by the specified separators
- Mark the Latin letters
- Mark Cyrillic letters
- Google Translate...

- Apply additional calculations to selected cells
- Change the formulas to their calculated values
- Converting unrecognized numbers (text?) to numbers
- Change value to text (adding ' in front)
- Fill the cells with their formatted value
- Change negative numbers to positive and vice versa
- Move the minus sign from the end to the beginning (for example, 47- to -47)
- Use a substantial number of commas
- Writing a number or sum in words
- Date conversion/recognition

TOP
# Change negative numbers to positive and vice versa

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

## Screenshot

## Launch this tool

## Do you recognize any of these situations?

## How much time will it save?

## Download

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.

Cells with formulas will be skipped.

After application:

Click

- 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?

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.

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

Additional keywords for this tool:

turn minus into plus, change the sign of numbers, convert numbers, convert negative values into positive ones

turn minus into plus, change the sign of numbers, convert numbers, convert negative values into positive ones

- 1. What is VBA, basic concepts.
- 2. Debugger (Debugger)
- 3. Work with sheets (Sheets)
- 4. Working with cells (Ranges)
- 5. Properties (Properties)
- 6.1. Data types (Variables)
- 6.2. Data Types (Continued)
- 7.1. Conditions (Conditions)
- 7.2. Terms (Continued)
- 8.1. Loops (Loops)
- 8.2. Cycles (Continued)
- 9. Procedures and functions
- 10. Dialog windows
- 11.1. Workbook events
- 11.2. Worksheet events
- 12.1. Custom forms
- 12.2. Controls (Controls)
- 12.3. Control elements (Continued)
- 12.4. Control elements (Exercises)
- 13.1. Arrays (Arrays)
- 13.2. Arrays (Continued)
- 13.3. Arrays (Exercises)
- 14.1. Using Excel functions
- 14.2. Creating a custom function

- 1. SQL language, basic concepts.
- 2. Data selection (SELECT)
- 3. Data sorting (ORDER BY)
- 4. Data filtering (WHERE)
- 5. Use of metacharacters (LIKE)
- 6. Calculation (calculation) fields
- 7. Data processing functions
- 8. Data grouping (GROUP BY)
- 9. Sub-requests
- 10. Combination of tables (INNER JOIN)
- 11. OUTER JOIN
- 12. Combined requests (UNION)
- 13. Adding data (INSERT INTO)
- 14. Creating tables (CREATE TABLE)

- Import of currency rates from the NBU website
- Sum written in English
- Unpivottables (Unpivot)
- Function
Google Translate - Camel Case Function
- Snake Case Function
- Kebab Case Function
- Break Case Function
- Sentence Case Function
- Title Case Function
Fuzzy Lookup Function- Function GETSUBSTR
- Free extension "YouLibreCalc"
- Professional Extension "YLC Utilities"