View Single Post
  #3   Report Post  
Paul Sheppard
 
Posts: n/a
Default value in words against the value in numbers- help needed


news Wrote:
From the cells B2 to B18 I have some values in USD.

In B19 the sum of B2 to B18 is there. ( for example $ 1250.85)

Now In the cell B21 I need the wording corresponding to the figure
found in
B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five
only)

Can any one help me.
t.thirumurthi


Try this link

http://www.excelforum.com/showthread...umbers+ words


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=478470