Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can excel give value in words of number entered in another cell?
I entered the amount 125 in the cell A1. I want excel to convert the value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say A2. The value in words should change automatically when I change the amount. Is there any formula for this? can any one help? |
#2
|
|||
|
|||
Try this: http://www.ozgrid.com/VBA/ValueToWords.htm
******************* ~Anne Troy www.OfficeArticles.com "nivedrajesh" wrote in message ... I entered the amount 125 in the cell A1. I want excel to convert the value in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say A2. The value in words should change automatically when I change the amount. Is there any formula for this? can any one help? |
#3
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP (remove nothere from the email address if mailing direct) "nivedrajesh" wrote in message ... I entered the amount 125 in the cell A1. I want excel to convert the value in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say A2. The value in words should change automatically when I change the amount. Is there any formula for this? can any one help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can excel give value in words of number entered in another cell?
"nivedrajesh" wrote: I entered the amount 125 in the cell A1. I want excel to convert the value in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say A2. The value in words should change automatically when I change the amount. Is there any formula for this? can any one help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can excel give value in words of number entered in another cell?
Try
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "V.V.Subbarao" wrote in message ... "nivedrajesh" wrote: I entered the amount 125 in the cell A1. I want excel to convert the value in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say A2. The value in words should change automatically when I change the amount. Is there any formula for this? can any one help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
How do I delete the "=" from a cell to give me the phone number I. | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions |