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 #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…