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;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.