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 ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
How to use the TEXT Function in Excel
Теги
Microsoft Excel (Software)TEXT FunctionTEXT FormulaConvert Number to TextApply Number Format to TextNumber FormattingExcel FormulasExcel FunctionsComputergagaAlan MurrayText FunctionsNumeric Valuestext function in excelexcel format numbers as textmicrosoft excel text functiontext functions in excelexcel for analystsexcel 2013excel text functiontext formula in excelhow to use text formula in exceltext function excel
