number convert to word in excel which formula

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.)


New Delhi, India


"Rafi Sharif" wrote:

number convert to word in excel which formula

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.

"Rafi Sharif" wrote:

number convert to word in excel which formula

Check:
http://www.bettersolutions.com/excel...B925012321.htm
for the UDF.

Salams & Best Regards,

FARAZ!

"Rafi Sharif" wrote:

number convert to word in excel which formula