Formatting
These examples may vary depending on the regional settings on your computer (for time, date and currency).
Formatting Numbers
Example: Label1.text = Format(123456.789, ",#.00") shows as 123,456.79
Format(123456.789) shows as if you used gb.Standard
http://Gambaswiki.org/wiki/cat/constant
Formatting Constants
| gb.Standard | Uses gb.GeneralNumber for formatting numbers and gb.GeneralDate for formatting dates and times. |
| gb.GeneralNumber | Writes a number with twelve decimal digits. Uses scientific format if its absolute value is lower than 10-4 (0.0001) or greater than 107 (1 million). |
| gb.Fixed | Equivalent to "0.00" |
| gb.Percent | Equivalent to "###%" |
| gb.Scientific | Write a number with its exponent (power of ten) and eighteen decimal digits. |
Symbols in the Format Strings
Symbols other than these print as they appear. For example, $ prints as is.
| + | Print the sign of the number. | Format(Pi, "+#.###") | +3.142 |
| - | Print the sign of the number only if it is negative. | Format(Pi, "-#.###") | 3.142 |
| # | Print a digit only if necessary.
One # before the decimal point is all that is needed. After the decimal point, as many #’s as you want decimal places. |
Format(123.456789, "#.###") | 123.457 |
| 0 | Always print a digit, padding with a zero if necessary. | Format(24.5, "$#.00") | $24.50 |
| . | Print the decimal point | Format(123.456, "#.0") | 123.5 |
| , | Separate the thousands | Format(1234567890, "#,")
Format(1234567890, ",#") |
1,234,567,890 |
| % | Multiply the number by 100 and print a percent sign. | Format(0.25, "#%") | 25% |
| E | This is Scientific Notation, which is
“Something-times-ten-to-the-power-of-something”. “E” means “times ten to the power of...” 1.2E+3 means "Start with 1.200, then move the decimal point three places to the right (get bigger x 1000) to become 1200." Negative numbers after the “E” mean move the decimal point to the left. |
Format(1234.5, "#.#E##")
Format(0.1234, "#.#E##") |
1.2E+3
1.2E-1 |
| $ | The national currency symbol (according to the country as set on your computer) | Format(-1234.56, "$,#.###") | -$1,234.56 |
| $$ | The international currency symbol (according to the country as set on your computer) | Format(-1234.56, "$$,#.###") | -AUD 1,234.56 |
| ( ) | Negative numbers represented with brackets, which is what finance people use. | Format(-123.4, "($$,#.00)") | (AUD 123.40) |
Formatting Dates
Example: Format(Now, gb.Standard) shows as 10/07/2019 21:07:26
Formatting Constants
| gb.GeneralDate | Write a date only if the date and time value has a date part, and write a time only if it has a date part. Writes nothing for a null date or a short time when there is no date, and writes the date and time for all other cases. | Format(Now, gb.GeneralDate) is 10/07/2019 21:17:45 |
| gb.Standard | Uses gb.GeneralNumber for formatting numbers and gb.GeneralDate for formatting dates and times. | 10/07/2019 21:20:45 |
| gb.LongDate | Long date format | Wednesday 10 July 2019 |
| gb.MediumDate | Medium date format | 10 Jul 2019 |
| gb.ShortDate | Short date format | 10/07/2019 |
| gb.LongTime | Long time format | 21:22:35 |
| gb.MediumTime | Medium time format | 09:23 PM |
| gb.ShortTime | Short time format | 21:23 |
Format String Symbols
Label1.text = Format(Now, "dddd dd/mm/yyyy hh:nn:ss") shows as Tuesday 09/07/2019 20:45:13
| yy | The year in two digits | h | The hour |
| yyyy | The year in four digits | hh | The hour in two digits. |
| m | The month | n | The minutes. |
| mm | The month in two digits. | nn | The minutes in two digits |
| mmm | Abbreviated month | s | The seconds |
| mmmm | Full name of the month | ss | The seconds in two digits |
| d | The day | : | The time separator |
| dd | The day in two digits | u | A point and the milliseconds, if non-zero |
| ddd | Abbreviated weekday | uu | A point and the milliseconds in three digits. |
| dddd | Full name of the weekday | t | The timezone alphabetic abbreviation |
| / | The date separator | tt | The timezone in HHMM format |
| AM/PM | The AM or PM symbol |
Formatting Currency
For the symbols in a format string, see above (numbers).
| gb.Currency | Uses the national currency symbol. | Format(14.50, gb.Currency)
shows as $ 14.5 |
| gb.International | Uses the international currency symbol. | Format(14.50, gb.International)
shows as AUD 14.5 |