FormatString

Syntaxc

FormatString(Value, Format)

Parameters

• Value: (string) The input value to be formatted.
• Format: (string) The format type, either “Currency” or “Numeric”.

Description

The FormatString function formats a given string based on the specified format. It supports formatting options like Currency and Numeric.

Example

TextBox1.Value=FormatString(100,Currency)

In this example, 100 is the input value that we want to format. The format type is “Currency”, which indicates that we want to format the input value as currency.

Figure1: Rule

Figure2: Preview