Register now or log in to join your professional community.
If you literally want to convert nos to words then you can use the 'SpellNumber' function by adding it through the VB Editor.
If you are looking to add alphanumeric or some other content to a cell then you need to format that cell to text. It can be done by adding a ' before the content to be entered.
To convert a numeric value into an English word, here is the formula you will need a numeric into english work
Example:
1. Press Alt+F11 > copy and paste in module (if module does not show insert module, click insert on menu bar >
Module)2. Alt+Q Save code and return to Excel sheet3. Insert > function > user defined > A1 or relevant cell.
In Excel
There is no a direct function of the expression of the figures in words
But i use one made by micro belong to "abo hagr "
someone who made micro function to convert numbers to words, but only in Arabic
it called "Altfiqit function " you can search for it by google by arabic words
in the down comment
add a ' in beginning '1234
