Forum Discussion
How to convert numbers into figures
Hi!
Can someone guide me to convert numbers into figures in excel. I need to incorporate this in monthly pay slip of employees.
10 Replies
search & download num2text utility save on desktop and go to option -add ins- scroll manage add ins and select excel add ins-browse - attached sheet - ok Ronald1969
After add ins the same jsut type =num2text(select value)+entre
you got as desired
- :crystal_ball:Convert Numbers To Word In Excel (Spell Number) | Excel VBA
https://youtu.be/eMA39dU3UOE- OK, thanks, I will try it.
You need some vba.
This is the User Defined Function (UDF) the code creates:
Code:
- Yes, thanks, I will try to do it.
- Numbers and figures are the same thing. Can you explain better what you mean?
I guess convert to text, e.g. instead of $10.00 it will be Ten and 00/100 Dollar or like
- Yes Sir, you are correct. Can you please help me on this. In excel I do my calculation and the amount normally appears in numeric value Rs. 1000 and for this I want it to be spelled in the next cell "One thousand Only" or "One thousand"
