Excel 2016 – How to force a value in a formula
Problem One of the more frustrating features in Excel is its ability to automatically change a cells format - based on it's content. For example - a cell a currency…
Currency
How to add currency suffix – add USD to end of value
The following code will add "USD" to the end of the U.S. Dollar currency in Gravity Forms. For example, instead of seeing $34.20 - $34.20 USD is displayed. This will not…
Crystal Reports – How to format number fields
The following steps show how to change the formatting of a number field in Crystal Reports - for example, to remove decimal places, add a currency symbol or add a…
SQL – How to format decimal to space delimited currency $ 1 234 567.89
The following SQL statement shows how to take a decimal value, e.g. 1234567.89 and convert it to a space delimited currency - that is, instead of using commas to separate…
Crystal Reports – How to format number as percentage
The following steps describe how to format a number so that it looks like a percentage. The obvious thing to point out is that there is no true 'percentage' value…
Is CloudFlare Pro worth getting?
CloudFlare is a popular service that speeds up websites by managing the websites DNS and routing traffic to a visitors closest cache of static content, such as images, CSS files and…
Word 2010 – Automatically Format Currency Mail Merge Fields
When using Word 2010 to create mail merges you can customise fields to automatically format the text or numbers as required. In this example we will be customising a merge…
Using ASP to connect to an Access Database
The following ASP script was used to pull information out of an Access database and publish it to a web page. IIS 7.0 was used as the web server application.…