How to use Text formula in Microsoft Excel
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.


In its simplest form, the TEXT function says:

=TEXT(Value you want to format, "Format code you want to apply")

Purpose 

Convert a number to text in a number format

Return value 

A number as text in the given format.

Syntax 

=TEXT (value, format_text)

Arguments 

value - The number to convert.

format_text - The number format to use.

Version 






#excel
#textfunction
#Docseazy