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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.