number convert to word in excel which formula
D DILipandey Apr 3, 2009 #2 Hi Rafi, to convert number to text, use TEXT function to convert text to number, use VALUE function Thanks. -- Click on Yes, if it is useful. Thanks & Best Regards, Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) [email protected] [email protected] New Delhi, India
Hi Rafi, to convert number to text, use TEXT function to convert text to number, use VALUE function Thanks. -- Click on Yes, if it is useful. Thanks & Best Regards, Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) [email protected] [email protected] New Delhi, India
F FARAZ QURESHI Apr 3, 2009 #3 If u want 1 to be converted to "one", u'll need a UDF, otherwise if 1 to "1" then =TEXT(D3,"0") I have a UDF if u want so.
If u want 1 to be converted to "one", u'll need a UDF, otherwise if 1 to "1" then =TEXT(D3,"0") I have a UDF if u want so.
F FARAZ QURESHI Apr 3, 2009 #4 Check: http://www.bettersolutions.com/excel/EIK284/QB925012321.htm for the UDF. Salams & Best Regards, FARAZ!
Check: http://www.bettersolutions.com/excel/EIK284/QB925012321.htm for the UDF. Salams & Best Regards, FARAZ!
