View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
V.V.Subbarao V.V.Subbarao is offline
external usenet poster
 
Posts: 1
Default 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?