diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2020-03-26 09:51:01 +0100 |
|---|---|---|
| committer | Mike Kaganski <mike.kaganski@collabora.com> | 2020-03-26 09:55:24 +0100 |
| commit | bb7b1fec521559170657017a193f4cc83fa8be3d (patch) | |
| tree | 1ef4943702b72ad26c5ee5450b35dbd6ca4cffcc /source | |
| parent | dac90072fecdfa76352153616f102d3229b5512e (diff) | |
Clarify TEXT spreadsheet function's first parameter (not only number)
Change-Id: Icf5c8a6ff2fe5f9238afdb9c35e22eb91937f778
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91106
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060110.xhp | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 22b1e92fd5..91ff8aa621 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -672,16 +672,17 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEXT" id="bm_id3156426" localize="false"/> <h2 id="hd_id3147132">TEXT</h2> -<paragraph id="par_id3147213" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEXT">Converts a number into text according to a given format.</ahelp></paragraph> +<paragraph id="par_id3147213" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEXT">Converts a value into text according to a given format.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3147377" role="code" xml-lang="en-US">TEXT(Number; Format)</paragraph> -<paragraph id="par_id3147389" role="paragraph" xml-lang="en-US"> <emph>Number</emph> is the numerical value to be converted.</paragraph> +<paragraph id="par_id3147377" role="code" xml-lang="en-US">TEXT(Value; Format)</paragraph> +<paragraph id="par_id3147389" role="paragraph" xml-lang="en-US"> <emph>Value</emph> is the value (numerical or textual) to be converted.</paragraph> <paragraph id="par_id3156167" role="paragraph" xml-lang="en-US"> <emph>Format</emph> is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id9044770" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT(12.34567;"###.##")</item> returns the text 12.35</paragraph> <paragraph id="par_id3674123" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph> +<paragraph id="par_id3674124" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT("xyz";"=== @ ===")</item> returns the text === xyz ===</paragraph> <tip id="par_id3145364">See also <link href="text/shared/01/05020301.xhp" name="Number format codes">Number format codes</link>: custom format codes defined by the user.</tip> </section> |