Movatterモバイル変換

Programming Gambas from Zip/Formatting

From Wikibooks, open books for an open world

These examples may vary depending on the regional settings on your computer (for time, date and currency).

Example: Label1.text = Format(123456.789, ",#.00") shows as 123,456.79

Format(123456.789) shows as if you usedgb.Standard

gb.Standard	Usesgb.GeneralNumber for formatting numbers andgb.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 10⁷ (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 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 isScientific 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)

Example: Format(Now, gb.Standard) shows as10/07/2019 21:07:26

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 anull 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	Usesgb.GeneralNumber for formatting numbers andgb.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

Label1.text =Format(Now, "dddd dd/mm/yyyy hh:nn:ss") shows asTuesday 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

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 asAUD 14.5

Programming Gambas from Zip
← DataTypes	Formatting	OperatorPrecedence →