LibreOffice 25.8 laguntza
Zenbakizko adierazpen bat kate bihurtzen du eta zehaztutako formatuaren araberako formatua ematen dio.
Format(adierazpena [, formatua As String]) As String
adierazpena: Formatudun kate bihurtuko den zenbakizko adierazpena.
format: String that specifies the format code for the number. If format is omitted, the Format function works like the LibreOffice Basic Str() function.
Testu-katea.
In BASIC, a format code can be divided into three sections that are separated by semicolons. The first part defines the format for positive values, the second part for negative values, and the third part for zero. If you only specify one format code, it applies to all numbers.
Hurrengo zerrendan, zenbakizko adierazpen bati formatua emateko erabili daitezkeen kodeak deskribatzen dira:
|
Code |
Description |
|---|---|
|
0 |
If expression has a digit at the position of the 0 in the format code, the digit is displayed, otherwise a zero is displayed. adierazpena adierazpenak formatua kodeko zero kopurua baino digitu gutxiago baditu (dezimalaren edozein aldetan), aurreko eta atzeko zeroak bistaratuko dira. adierazpenak formatua kodeak duen zero kopurua baino digitu gehiago baditu dezimalen bereizlearen ezkerrean, gainerako digituak formateatu gabe bistaratuko dira. adierazpena adierazpeneko dezimalak borobildu egingo dira formatua kodeko dezimal-bereizlearen ondoren agertzen diren zero kopuruaren arabera. |
|
# |
If expression contains a digit at the position of the # placeholder in the format code, the digit is displayed, otherwise nothing is displayed at this position. Ikur honek 0 zenbakiaren moduan funtzionatzen du, baina aurreko eta atzeko zeroak ez dira bistaratzen # karaktere gehiago badaude formatua kodean, adierazpena adierazpenean dauden digituak baino. adierazpena adierazpeneko digitu esanguratsuak soilik bistaratuko dira. |
|
. (period) |
The decimal placeholder determines the number of decimal places to the left and right of the decimal separator. formatua kodeak # leku-markak soilik baditu ikur horren ezkerrean, 1 baino txikiagoko zenbakiek dezimalen bereizle bat izango dute hasieran. Zenbaki zatikiarretan aurreko zeroa beti bistaratzeko, erabili 0 leku-marka gisa dezimalen bereizlearen ezkerreko lehenengo digituan. Puntua milakoen eta dezimalen bereizle gisa erabiltzea eskualdeko ezarpenen arabera dago. Zenbaki bat zuzenean Basic iturburu-kodean sartzean, puntua erabili beti dezimal-bereizle gisa. Unean dezimalen bereizle gisa bistaratutako karakterea zure sistemako ezarpenen zenbaki-formatuaren arabera dago. |
|
% |
Multiplies the expressionby 100 and inserts the percent sign (%) where the expression appears in the format code. |
|
E- E+ e- e+ |
If the format code contains at least one digit placeholder (0 or #) to the right of the symbol E-, E+, e-, or e+, the expression is formatted in the scientific or exponential format. The letter E or e is inserted between the number and the exponent. The number of placeholders for digits to the right of the symbol determines the number of digits in the exponent. Esponentea negatiboa bada, minus ikurra bistaratuko da berehala esponente baten aurrean honako ikurrekin: E-, E+, e-, e+. Esponentea positiboa bada, plus ikurra bakarrik bistaratuko da esponenteen aurrean E+ edo e+ ikurrarekin. |
|
- + $ ( ) space |
: A plus (+), minus (-), dollar ($), space, or brackets entered directly in the format code is displayed as a literal character. |
|
\ |
Hemen zerrendatzen ez diren karaktereak bistaratzeko, aurrean alderantzizko barra (\) jarri behar diezu, edo komatxo artean (" ") jarri behar dituzu. The backslash displays the next character in the format code. Esanahi berezia duten eta formatua kodean ageri diren karaktereak modu literalean bistaratu nahi badira, aurretik alderantzizko barra eraman behar dute. Alderantzizko barra bera ez da bistaratuko, salbu eta formatu-kodean alderantzizko barra bi aldiz jarraian (\\) sartzen bada. Karaktere gisa bistaratu ahal izateko formatu-kodean aurretik alderantzizko barra izan behar duten karaktereak hauek dira: data- eta denbora-formatuko karaktereak (a, c, d, h, m, n, p, q, s, t, w, y, /, :), zenbaki-formatuko karaktereak (#, 0, %, E, e, koma, puntua) eta kate-formatuko karaktereak (@, &, <, >, !). |
Aurredefinitutako ondorengo zenbaki-formatuak ere erabil daitezke. "General Number" izan ezik, aurredefinitutako formatu-kode guztiek zenbaki dezimal gisa, bi dezimalekin, itzultzen dituzte zenbakiak.
Aurrez definitutako formatuak erabiltzen badituzu, formatuaren izenak komatxo artean egon behar du.
|
Code |
Description |
|---|---|
|
"<" |
Convert expression to lower case |
|
">" |
Convert expression to upper case. |
|
"c" or "General Date" |
Returns the numeric expression in short date format, optionally with "H:MM:SS AM/PM". If expression is a string, returns the string. |
|
"n" |
Returns the minute of the numeric expression, with 1 or 2 digits. |
|
"nn" |
Returns the minute of the numeric expression with two digits. |
|
"w" |
Returns the week day of the numeric expression. 1 is Sunday and 7 is Saturday. |
|
"General Number" |
Returns the numeric expression with 12 digits (0.############). |
|
"Currency" |
Returns the numeric expression in the currency of the locale. |
|
"Fixed" |
Returns the numeric expression with 2 decimal places (0.00). |
|
"Standard" |
Returns the numeric expression with thousands separators and 2 decimals (@0.00). |
|
"Percent" |
Returns the numeric expression as percent value (0.00%). |
|
"Scientific" |
Returns the numeric expression in scientific notation (#.00E+00); |
|
"Yes/No" |
Returns "Yes" if the numeric expression is not equal to zero, "No" otherwise. "Yes" and "No" are localized. |
|
"True/False" |
Returns "True" if the numeric expression is not equal to zero, "False" otherwise. "True" and "False" are localized. |
|
"On/Off" |
Returns "On" if the numeric expression is not equal to zero, "Off" otherwise. "On" and "Off" are localized. |
|
"Long Date" or "dddddd" |
Returns the numeric expression in system long date format, and depends on the locale. |
|
"Medium Date" |
Returns the numeric expression in date format DD-MMM-YY, and depends on the locale. |
|
"Short Date" or "ddddd" |
Returns the numeric expression in system short date format, and depends on the locale. |
|
"Long Time" or "ttttt" |
Returns the numeric expression in system long time format, and depends on the locale("H:MM:SS AM/PM"). |
|
"Medium Time" |
Returns the numeric expression in system medium time format, and depends on the locale (HH:MM AM/PM) |
|
"Short Time" |
Returns the numeric expression in system short time format, and depends on the locale (HH:MM). |
Sub ExampleFormat
MsgBox Format(6328.2, "##,##0.00")
' puntua erabili beti dezimal-bereizle gisa Basic iturburu-kodean zenbakiak sartzean.
' adibidez, ingeleseko eskualde-ezarpenean 6,328.20 bistaratzen du, alemanekoan 6.328,20.
msgbox Format("ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890", "<") ' returns abcdefghijklmnopqrstuvwxyz1234567890, digits not affected.
msgbox Format("abcdefghijklmnopqrstuvwxyz1234567890", ">") ' returns ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890, digits not affected.
msgBox Format(12345.6,"c") ' returns the number in date format as 18/10/33 2:24:00 PM in German locale.
msgBox Format(12345.6,"General Date") ' Same as "c".
msgbox format(12345.004,"n") ' returns 5
msgbox format(12345.004,"nn") ' returns 05
msgbox format(12345.6,"w") ' returns 4 (Wednesday).
msgbox format(log(123),"General Number") ' returns 4,812184355372 in German locale
msgbox format(123456.7890,"Fixed") ' 123456.79
msgbox format(123456.1234,"Fixed") ' 123456.12
msgbox format(123456.7890,"Standard") '123,456.79
msgbox format(123456.1234,"Standard") '123,456.12
msgbox format(12.3456,"Percent") ' 1234.56%
msgbox format(0.123456,"Percent") '12.35%
msgbox format(123,"Yes/No") ' returns localized "Yes"
msgbox format(0,"Yes/No") ' returns localized "No"
msgbox format(-1,"True/False") ' returns localized "True"
msgbox format(123,"On/Off") ' returns localized "On"
msgbox format(45756.73,"Long Date") ' returns Wednesday, April 9, 2025 in your locale
End Sub