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…
VALUE
Crystal Reports – How to test if string contains
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…
Crystal Reports – How to convert text date to datetime format
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…
SQL – How to convert line separated text to comma separated
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…
Disable autoplay videos in Firefox
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…
Excel 2016 – How to filter pivot table data
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…
Excel 2016 – What is #DIV/0! error and how to fix it?
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…
Excel 2016 – How to exclude (blank) values from pivot table
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…
How to create named cell references in Excel 2016
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…