Format() returns a Variant (convertible to a String) data type formatted to look the way you need. Format() does not change a value, but Format() changes the way a value looks. Here is the format of Format():

   Format(Expression, strFormat)

strFormat values

"Currency"

Ensures that a dollar sign ($) appears before the formatted value, followed by a thousands separator (a decimal point or comma for values over 999; your country setting determines whether the thousands separator is a comma or a decimal).   

Two decimal places will always show. Visual Basic displays negative values in parentheses.

"Fixed"

Displays at least one digit before and two digits following the decimal point, with no thousands separator.

"General Number"

Displays the number with no thousands separator.   

"Medium Time" Displays the time in 12-hour format and the a.m. or p.m. indicator.

"On/Off"

Displays On if the value contains a nonzero or True value and displays Off if the value contains zero or a False value.

"Percent"

Displays the number, multiplied by 100, and adds the percent sign to the right of the number. "Scientific" Displays numbers in scientific notation.

"Short Time"

Displays the time in 24-hour format.

"True/False"

Displays True if the value contains a nonzero or True value, and displays False if the value contains zero or a False value.

"Yes/No"

Displays Yes if the value contains a nonzero or True value and displays No if the value contains zero or a False value.

ex:

  FormValue(1) = Format(12345.678, "Currency")

  FormValue(2) = Format(12345.678, "Fixed")