number convert to word in excel which formula

  • Thread starter Thread starter Rafi Sharif
  • Start date Start date
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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to Convert Numbers to Words 4
Excel Convert word into numbers and back 4
Convert the amount into a word format 2
Which is the best MBOX Converter Tool different formats conversion? 4
Converting numbers to words 1
Calculate number of rows and apply formula 4
formula to count text entries and return text with most entries 8
convert number value to words of numerical value 4

Back
Top