LibreOffice 25.2 Help
Converts a value into text according to a given format.
TEXT(Value; Format)
Value is the value (numerical or textual) to be converted.
αααααααααΆα ααΆβα’αααααβαααβαααααβαααααααααΆαΒ α ααααΎββα ααα½αβααααΆα αα·αβα’αααβαααααβαααααβααΆαα αααβα’αΆαααααβααΆαβαααα»αβααΆααΆβαααα»αβαααααααααΆαβαααα‘αΆΒ α
=TEXT(12.34567;"###.##") αααα‘ααβα’ααααα 12.35
=TEXT(12.34567;"000.00") αααα‘ααβα’ααααα 012.35
=TEXT("xyz";"=== @ ===") returns the text === xyz ===
See also Number format codes: custom format codes defined by the user.