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)

To know more about 𝐓𝐞𝐱𝐭 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:-

Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe –

Tag: excel text function, text function in excel, text function in excel definition, text function excel, excel text function, text excel formula

Xem thêm: https://kênhonline.vn/category/internet

Nguồn: https://kênhonline.vn

Leave a Reply

Your email address will not be published. Required fields are marked *