Tuesday, March 5, 2013

Spellnumber in EXCEL


SPELLNUMBER IN EXCEL


=bhola( )  function

1. Start Microsoft Excel.


2. Press ALT+F11 to start the Visual Basic Editor.


 3. On the Insert menu, click Module.



4. Download code copy and paste into the module.


5. Close visual basic editor.



6. Goto cell D2 type 999999999 then in cell D3 type =bhola (bhola function ready to work.)


7. Goto cell D3 type =bhola(D2) press enter.
                                                  

8. Magic you have done……. Now you can convert any digits in your word currency system.