G Guest Mar 5, 2005 #1 IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED"
IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED"
A Andy Brown Mar 5, 2005 #2 Jaya said: IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED" Click to expand... There's no built-in function AFAIK. Try the custom function @ http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 Rgds, Andy
Jaya said: IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED" Click to expand... There's no built-in function AFAIK. Try the custom function @ http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 Rgds, Andy
