TEXT Function in Excel | Formula | Use of TEXT Function in Excel

In this video, we are going to learn how to use Text function in excel using Text Formula.

𝐓𝐞𝐱𝐭 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
-------------------------------------------

The text function in excel coverts the numerical values into a text format stated.

𝐓𝐞𝐱𝐭 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
---------------------------------------

Below is the formula of Text Function

= TEXT (value, format_text)

𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
----------------------------

Value = Value to be formatted.

format_text = Format code we would like to apply.

𝐓𝐞𝐱𝐭 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐅𝐨𝐫𝐦𝐚𝐭 𝐂𝐨𝐝𝐞 𝐃𝐮𝐫𝐢𝐧𝐠 𝐃𝐚𝐭𝐞 𝐇𝐚𝐧𝐝𝐥𝐢𝐧𝐠
-----------------------------------------------------------------------------------------

Format Code Description Using Text Function Output

d It shows the day 12 12
as a number without
a leading zero.

m It shows the month 1 1
as a number without
a leading zero.

yy It shows the year 18 or 2018 18 or 2018
as a 2 digit no(00-99)
or 4 digit number(1990-9999)