TEXT

Converts a value into text according to a given format.

TEXT(Value; Format)

Value is the value (numerical or textual) to be converted.

Format is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.

=TEXT(12,34567;"###,##") tagastab tekstistringi 12,35

=TEXT(12,34567;"000,00") tagastab tekstistringi 012,35

=TEXT("xyz";"=== @ ===") returns the text === xyz ===