TEXT
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;"###.##") returns the text 12.35
=TEXT(12.34567;"000.00") returns the text 012.35
=TEXT("xyz";"=== @ ===") returns the text === xyz ===
See also Number format codes: custom format codes defined by the user.