## Excel – How to convert negative/positive numbers

The following steps show how to bulk convert negative or positive numbers. Negative numbers (-1) become positive numbers (1) Positive numbers (1) become negative numbers (-1) There are two ways…

Skip to content
## VALUE

## Excel – How to convert negative/positive numbers

## Crystal Reports – How to test if string contains

## Crystal Reports – How to convert text date to datetime format

## SQL – How to convert line separated text to comma separated

## Disable autoplay videos in Firefox

## Excel 2016 – How to filter pivot table data

## Excel 2016 – What is #DIV/0! error and how to fix it?

## Excel 2016 – How to exclude (blank) values from pivot table

## How to create named cell references in Excel 2016

The following steps show how to bulk convert negative or positive numbers. Negative numbers (-1) become positive numbers (1) Positive numbers (1) become negative numbers (-1) There are two ways…

The following formula shows how to test if a text field contains particular text. For example: Value Formula Result a quick brown fox InStr( {value}, 'red' ) false a quick…

Text of dates in Crystal Reports can be annoying - you can't apply any date-specific formatting or use the date in formulas - because it is after all, just the…

The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we had a table with the following data Lucky_Numbers 2 33…

Unlike Google Chrome - it's quite easy to disable autoplay videos in Firefox. The functionality is built right into Firefox- meaning no third-party extensions required. While it's not absolutely perfect…

The steps below will show how to hide data from a pivot table based on the value. In this example we'll be hiding data where the value is 0. In…

The #DIV/0! error message means "divide by zero" - a division which is mathematically impossible, hence the error. When you see this it's because you have a formula which is trying…

If you need to create a pivot table chart on a range that includes blank rows you'll end up with a (blank) label. There are several suggested ways to remove…

Cell references in Excel formulas typically use their position in the worksheet - e.g. A2 for a single cell or A2:A4 for a range. But as formulas get more complicated…