How to use the TEXT Function in Excel

How to use the TEXT function in Excel. The TEXT function is used to convert a number to text in a specified number format.

This function is great when concatenating numeric values into a text string. The number is converted to text but still displayed in its date, currency, percentage or another number format.

This video tutorial demonstrates two examples of how to use the TEXT function. The first concatenates a date value and the second a calculated value in a currency format.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[Chef-]

Thats super helpful and much appreciated. Love all the little tips that make things so much easier.

[sasavienne]

Thanks for the very useful and informative tutorials. It is so kind of you to share this valuable knowledge. You deserve my respect and my unlimited gratitude.

[dadwarkh]

Hi. thanks for the informative video, I was expecting a formula that may turn the number to the text noun of it. like 4 becomes four. which may be used to automate the total value of bills.

[chascarpenter]

Had to watch it several times to get it to sink in, but doubt i will ever have to use it in my data base, however, I am still trying to find the answer in your videos to adding (304) to a number in column A to a figure & getting the added number of the two in B, I have subscribed to your channel & find it easy to learn from you, Thank you.

[dickyrock]

Thanks man, good simple video, appreciate it.

[ianodonoghue]

Hi Alan very useful video. Really helpful for me when doing notes for financial statements at work.
Thanks

[krismaly]

i ENJOYED WATCHING THIS VIDEO AND RECOMMEND OTHERS TO WATCH.

Thanks for educating the community and appreciate your volunteer-ship

Question
Is there no function in Excel to REVERSE a word or string like

ABC to CBA

'How are you' to 'uoy era woH'

Thanks a lot

[johnefokwu]

Thanks man. Simple and effective presentation

[daohiotrollwall]

Thankyou
I really like your informative videos keep going btw you helped me alot bc my IT practical is coming and i really needed this
Btw i am from 8 class and love you from India keep going my blessings is with you :)

[padamsinh]

Hi I am working on two sheets but there is some cells are getting correct answer and other are showing NA error i am not able to sure both refrence file format is number or Text How i can change format of data

[RajKumar-kuqz]

Thanks for this is useful text function.

[ICCHighlights]

Thanks, I was stuck in this step. Your video help me out from pickle.

[MrDazza]

Hi Alan,
Excellent informative videos. Please keep doing them. I have signed up to emails and the e-book.
I'm a newbie but picking things up with your helpful videos. Can I ask if you have copies of example worksheets with formulas so that I can follow the steps in an interactive way whilst watching the videos.
Also how do you insert /split a cell without affecting the cells underneath that already have formatting? When I try it affects the below formatting especially if the cells have been merged/centred. Apologies if this is so basic but I'm just starting out at age 50 so a bit late to all this.
My intention is to learn how to produce both weekly and monthly production schedules which include job numbers, people, job status etc.Eventually I will calculate dates which are over due and total jobs per month/year. Eventually link monthly/ yearly to a graph but haven't got round to graphs yet lol

Regards

Darren

[locochon]

I just want add == to a cell without put "==", that's possible?

[Yumi-fbrw]

ah damn thanks man
Ive been trying to add text to a file I needed, kinda used the IF funktion to do that and then added TEXT into it then SUM.
That took so long and didnt even work in the end

[unTOLD-IT]

Is there shortcut for text function in 2007 version ?

[compscript]

Not acceptable for a mass amount of data with many formats.
I want to take special formatting and add text to it so that it never ever changes formatting.

[ahmetcevik]

Hi! When I wrote down all the formula as exactly as you do in the video my dates show off like this "dd/mm/1974" :D :D I did the same thing with you! What's wrong in my formula ? Thank you :)

[SuperNukki]

I have a CSV file, i need to add "0" at first number entries in the cell, for example i already type 0812990088, as default excel only read 812990088 (without 0) then i tried to add ( ' ) in front of 0 and become like this '0812990088. after i saved the CSV and re-open it again, 0 in the front of numbers not appear, even i changed format cells as a text. How to keep 0 still appear on CSV format ?
Please advise sir