How to convert FIGURES in one column to WORDS in another column?

I want to get the amounts put in one column in "Figures" to appear it in
another column in "Words" . Is it possible in Excel ? See below to have a
clear idea about what I am saying.

Example-
USD:1,013,566.38 (in Column A) to Appear As "USD:One Million Thirteen
Thousand Five Hundred Sixty-six & Cents Thirty-eight only"

Please Guide, if anybody can.

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

--
Kind regards,

Niek Otten

"Shashank Virkar" <Shashank Virkar@discussions.microsoft.com> wrote in
message news:282246B7-52DA-44BB-9912-84C07D58CDA3@microsoft.com...
>I want to get the amounts put in one column in "Figures" to appear it in
> another column in "Words" . Is it possible in Excel ? See below to have a
> clear idea about what I am saying.
>
> Example-
> USD:1,013,566.38 (in Column A) to Appear As "USD:One Million Thirteen
> Thousand Five Hundred Sixty-six & Cents Thirty-eight only"
>
> Please Guide, if anybody can.
>
>
>
>

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;Q213360&;

and:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;q140704&;


--
Gary''s Student


"Shashank Virkar" wrote:

> I want to get the amounts put in one column in "Figures" to appear it in
> another column in "Words" . Is it possible in Excel ? See below to have a
> clear idea about what I am saying.
>
> Example-
> USD:1,013,566.38 (in Column A) to Appear As "USD:One Million Thirteen
> Thousand Five Hundred Sixty-six & Cents Thirty-eight only"
>
> Please Guide, if anybody can.
>
>
>
>