Description

TEXT is categorized as text function in Excel. It converts the value into text in the specified format. Having two arguments where first one is value, the value you want to convert into text and other one is format, the format in which you want to convert.TEXT function is very useful in adding a specific number or date format in a text string

Syntax

TEXT( value, format )

Example

  1. Using TEXT Excel function you can convert a value in required format and can also concatenate with text string

0 Comments

By Rajesh K Saraogi

Rajesh is a hardcore finance person with a penchant for latest technology. His passions are latest technology and to improve the productivity with simple, yet powerful software – mainly on Microsoft Excel platform. He is a qualified MCA. Whenever he gets time he loves to blog, to share the knowledge, which is the only thing which increases after sharing!