For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

TEXT Function

TEXT Function

Converts a value to text, using the specified number format


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

xxxxxxx

Syntax

TEXT(value, format_text)

  • value  Required. The numeric value to be converted to text, or a refernce to that value.

  • format_text  Required. A number format from the Format Cells dialog box in text format. Format_text cannot be an asterisk (*).

Applies To

Excel 2003 and above

Remarks

xxx

Examples

xxx

Other ExcelUser Information

xxx

Other Help

  • Microsoft Help for the xxx Function

 

Charley's SwipeFile charts


Free Excel Dashboards