Question about formula

[bilind]

can you help me how can i convert the number to text please?

 

[Montrey]

=text(

 

[Faseeh]

Hi bilind,


Welcome to the Chandoo's forum. To elaborate a Little more it should be:

=TEXT(B1,"0.00")

..where B1 contains numeric value or you can simply select the Range of Cells and format numbers as text.


Regards,

Faseeh

 

[oldchippy]

Hi,


Or maybe this?


http://chandoo.org/forums/topic/converting-text-to-numbers-and-vice-versa