Converting No. to Text

[sgmpatnaik]

Hello Sir,


Here i am going to ask a fullish question which i want convert a No. into Text but i can't


suppose 12345 is a No. now i want to convert it with (Rupees Twelve Thousand Three Hundred Forty Five) but it's displaying some other language which i can't understand


kindly help me

 

[Hui]

SP

Have a read of: http://chandoo.org/forums/topic/how-to-convert-numbers-to-text

 

[sgmpatnaik]

hello sir good to see you again


little bit confuse to use the code


will you please help me

 

[Hui]

SP the Microsoft link walks you through the process quite well

http://support.microsoft.com/kb/213360

Where are you stuck ?

 

[sgmpatnaik]

I AM EXTREMELY SORRY SIR


I COPY THE ENTIRE CODE AND PASTE IN THE MODEL BUT I DON'T HOW TO USE THAT FARMULA

 

[Hui]

Did you copy the code into a Module in your workbook in VBA ?

If you did you should be able to goo back to excel and use a formula like :

=SpellNumber(A1)

or

=SpellNumber(12345)


Can you post your Workbook somewhere?

 

[sgmpatnaik]

NO SIR AND WHICH BOOK ABOUT YOU TAKING

 

[sgmpatnaik]

yes i can

 

[Hui]

SP


The instructions at http://support.microsoft.com/kb/213360

are very clear and precise

They must be followed word for word


The Workbook is your Workbook where you want to convert the number 123345 to Text

[Excel uses the word Workbook to refer to a file containing a number of Worksheets (Pages), Sometimes people call these files spreadsheets.]