[PDF]Text Function In Excel

Imparting knawledga

Cyan Sangrah

Text function in excel

In this article, we will discuss Text function in excel.

Purpose

Text function converts numbers (or dates) into text format.

Syntax

TEXT (“value”, "format")



Example








T E XT{TO D AY{ );■ d d - M M M-VY vv")

Equals to

04-NOV-2018



TEXT(4 *5 * 7/###.00”)

Equals to

140.00



TEXT(91999999999;'{##) ###-##-##-##”)

Equals to

(91) 999-99-99-99