'

Used for – ‘ Function in MS Excel is used to convert number into text so that MS excel read number as text.

Syntax – ‘ is syntax in itself i.e. no syntax is used for it.


Example – Suppose you want to write 001 in a cell but it automatically change to 1 then simply write’001 in a cell and excel will read it as text and displays as 001.