Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value shows in words
Hello,
I suggest to use my UDF spellnumber: http://www.sulprobil.com/html/spellnumber.html Regards, Bernd |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
Value shows but should not print | Excel Discussion (Misc queries) | |||
Date shows as 01/01/00 | Excel Discussion (Misc queries) | |||
cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) |