value in words against the value in numbers- help needed

[news]

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

[Paul Sheppard]

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...+numbers+words

[bpeltzer]

Check the MS site for 'spellnumber':
http://support.microsoft.com/default...b;en-us;213360

"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
>
>
>

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"news" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>