convert numeric data type to character data type in excel

[JIGYANSHA1985]

Sir,
How should I convert the numeric data type into character datatype using function....

A B
12 12
54 54
67 67

[HansV]

You can use

=TEXT(A1,"0")

if you only have whole numbers, or

=TEXT(A1,"0.00")

if you want to format the value with two decimal places, or

=TEXT(A1,"@")

if you want to convert the value "as is" to text.

[JIGYANSHA1985]

Thanks a lot ..