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
54
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

1 reply

sgmpatnaik
Posts
54
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