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.
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"
- At least couple of non-VBA solutions was published here, and there are more if google them.
- Ok, thanks, I will try to find out. I thought, I I could download from some link and start using it instantly, that would help me to finish the task assigned to me at the earliest. Anyway, meantime I will try and search. Thanks once again.
