There are third part add in for excel (Longre) calle "Moreucntions" which ahs number very good function. If you donwload this addin file and isntal as addin then when click insert function you will get one item more function in this there is a function called NBtext with some arguments this will convert your 10 into ten
|
Select an empty cell. if you clicck fx before the formula bar you will get the name of the functions
|
I hope you have added this addin. You must be knowing how to add an addin
|