Use the Excel TEXT Function to Display Numbers as Words

Learn how to display numbers as text in Excel. You'll learn the secret for how to convert raw numbers into easily readable text in your spreadsheets. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: bit.ly/exceltext #excel #exceltutorials #microsoft365

[@colourfulpisces8088]

Thank you. You explained it perfect. You didn't go fast either to where I had to pause to take notes... Great help. Keep doing what you're doing!!

[@techteachersandstudents]

Glad it helped!

[@habibasuleimanharuna3727]

Thanks for sharing it’s very much helpful, looking forward to watching more of your videos 👍

[@HamdanYouTuber]

Another useful video from this channel, thank you. 👍

[@XLLearner_Courses]

TEXT functions. So useful

[@simoiyahector-morales3781]

Excellent tutorial 👌 👍🏽 👏

[@masiqbalGO]

Thanks for topics education in this video 🙏

[@ouahibabela8986]

Many many many thanks

[@machungapachuau7101]

Nice.... Great job, thanks...

[@sophanasorn6218]

Great tutorial

[@myklopez9843]

New subs here from the Philippines....

[@yuelalex2893]

Hello TFTS I am have been following of you for a while. Just What I want you to make us Video is how to easily convert numbers to alphabets. eg... 101= One hundred one like this...

[@prasannarana9602]

this was helpful. btw, is there a video made by you regarding date conversion from mm/dd/yyyy to dd/mm/yyyy. say, I type in format 28/02/2022 but I can't format it to dd/mm/yyyy

[@showrobislam2379]

Thanks

[@snoringdragon1980]

Hi, I have a set of labels in word. How do I put a set of addresses in a label format from word to excel?

[@sharonkatzman7724]

What if I want Ashland, VA to equal $1200...how do you format the cell to achieve this result? Thanks

[@user-uh2eo8kg6k]

Excel formula so that when you place a number in a cell, the number written in letters appears in the next cell

[@hectorcomerez2523]

Hey, you should leave the Excel sheet so we can practice.

[@byronwatkins2565]

Your little "th" trick will not work correctly for the first, second, or third.

[@rohateanonis4657]

was wondering same but I have a long complicated way with IF function.

[@techteachersandstudents]

Good point, but my main message there is just that you can intermix numbers and text.

[@francespinckney1482]

Don't like popping up in my presentation.