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 āĻšāĻ˛ā§ āĻāĻāĻāĻŋ āĻā§āĻā§āĻ¸āĻ, āĻ¯āĻž āĻĢāĻ°āĻŽā§āĻ¯āĻžāĻ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻāĻ°ā§āĨ¤ āĻāĻ°ā§āĻ° āĻŦāĻŋāĻ¨ā§āĻ¯āĻžāĻ¸ā§ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŋāĻ¤ āĻāĻžāĻˇāĻž āĻ āĻ¨ā§āĻ¸āĻžāĻ°ā§ āĻĻāĻļāĻŽāĻŋāĻ āĻāĻŦāĻ āĻ¸āĻšāĻ¸ā§āĻ° āĻŦāĻŋāĻāĻžāĻāĻ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°ā§āĻ¨āĨ¤
=TEXT(12.34567;"###.##") ā§§ā§¨.ā§Šā§Ģ āĻ˛ā§āĻāĻž āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§
=TEXT(12.34567;"000.00") ā§Ļā§§ā§¨.ā§Šā§Ģ āĻ˛ā§āĻāĻž āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§
=TEXT("xyz";"=== @ ===") returns the text === xyz ===
See also Number format codes: custom format codes defined by the user.