number convert to word in excel which formula
 

number convert to word in excel which formula

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

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

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