How to convert number to text in excel formula?

Question

3 answer(s)

Answer # 2 #

Alternatively, use &"" trick: =A1&"" to convert a number into text quickly.

Answered by: Moinak Wilbanks [2 Month]

(4)

Answer # 3 #

Use the TEXT function: =TEXT(1234,"0") converts the number 1234 into text “1234”.

Answered by: Guest Erddlgvxy [3 Month]

(4)

Answered by: Severin Stites · Accepted Answer

Answer # 1 #

For more complex formats, you can use: =TEXT(A1,"₹#,##0.00") to convert a number into currency format as text.

Answered by: Severin Stites [2 Month]

(5)