Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

TEXT

Description: Converts a value to text in a specific format.

Syntax: TEXT(Value, Format_text)

Remarks:

Example:

If cells A2:A3 contain Buchanan and Dodsworth, respectively, and cells B2:B3 contain 2800 and 40%, respectively:

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.