Num Convert to text in Excel 2007

Solved/Closed
Rupendra Singh Posts 1 Registration date Monday April 29, 2013 Status Member Last seen April 29, 2013 - Apr 29, 2013 at 07:20 AM
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 30, 2013 at 01:10 AM
R/Sir,


As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num convert inyo million ,but i have change programming Lakh replece of million. than programm is not give true answer (for Exemple 7052312 show in word seven lakh fifty two thousand three hundred twelve).

and i also want to after amout wright Only Word.

Thanks
Related:

1 response

sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Apr 30, 2013 at 01:10 AM
@Rupendra Singh

Hi

You need to create one UDF so please check the below mention link there already replay for Convert Number into Text

https://ccm.net/forum/affich-694592-formula-in-excel-to-turn-numbers-into-text

Hope it is solve your problem other wise please inform us

we will wait for your response

Thanks

Patnaik
2