TEXT

Converts a value into text according to a given format.

TEXT(Value; Format)

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

Dhangiin barruu dhangii ibsudha. Haala afaan dhangii mandhee keessatti qindaa'een gargarbaastota dessimaalii ykn kumootaa fayyadami.

=TEXT(12.34567;"###.##") barruu 12.35 deebisa

=TEXT(12.34567;"000.00") barruu 012.35 deebisa

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