ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   value shows in words (https://www.excelbanter.com/excel-worksheet-functions/214753-value-shows-words.html)

Amount need to be shown in words

value shows in words
 
Ihave an excel sheet. and there is a column called A1= "Value" there I will
put the amount of an employee.... the next column called " Amount in words"
I need to get the value in words which I am putting on the "Value" column..
How can I get that problem solved.

Regards-
Mujeeb.


Bernd P

value shows in words
 
Hello,

I suggest to use my UDF spellnumber:
http://www.sulprobil.com/html/spellnumber.html

Regards,
Bernd

Shane Devenshire

value shows in words
 
Hi,

You can get free code to convert numerical entries to text, such as 123 to
One Hundred Twenty Three, at the following web site:

http://support.microsoft.com/kb/213360


If this help, please click the Yes button.

Cheers,
Shane Devenshire

"Amount need to be shown in words" <Amount need to be shown in
wrote in message
...
Ihave an excel sheet. and there is a column called A1= "Value" there I
will
put the amount of an employee.... the next column called " Amount in
words"
I need to get the value in words which I am putting on the "Value"
column..
How can I get that problem solved.

Regards-
Mujeeb.



All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com