Sometimes we suffer huge to convert numeric values to English words while using Excel. you can try bellow simple steps to make it simple.
Steps:
1. Open Excel File
2. Press Ctrl+F11
3. Go to "Insert" Menu & click on "Module"
4. Get the desired codes by clicking bellow Links & Pest it to the module
5. Click on "Save" button & Click on "No" Button in the new window
6. Save the file to your desired location, selecting file type as "Excel Macro-Enabled Workbook"
7. Press "Ctrl+Q"8. Then write the formula to the desired cell Like: =SpellNumber(K20)
9. Input any number to the cell number (K20) and press "Enter" to see the result
1. Open Excel File
2. Press Ctrl+F11
 |
| 3. Go to "Insert" Menu & click on "Module" |
 |
| 4. Get the desired codes by clicking bellow Links & Pest it to the module |
 |
| 5. Click on "Save" button & Click on "No" Button in the new window |
 |
| 6. Save the file to your desired location, selecting file type as "Excel Macro-Enabled Workbook"7. Press "Ctrl+Q" |
 |
| 8. Then write the formula to the desired cell Like: =SpellNumber(K20) |
 |
9. Input any number to the cell number (K20) and press "Enter" the see the result
|
Links:
Click here to get Codes For For the Currency Dollar & Cents
Click here to get Codes For the Currency Taka & Paisa
Number To Word- Excel File For Check
No comments:
Post a Comment