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

0



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 *