I want to get the words for digits...eg. If I enter 4526 in a column , i need
to get "four thousand five hundred twenty six" in another column
automatically.....
How can I do it? How make a formulae for this.
I want to get the words for digits...eg. If I enter 4526 in a column , i need
to get "four thousand five hundred twenty six" in another column
automatically.....
How can I do it? How make a formulae for this.
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...EN-US;q140704&
--
Gary''s Student
"Excel" wrote:
> I want to get the words for digits...eg. If I enter 4526 in a column , i need
> to get "four thousand five hundred twenty six" in another column
> automatically.....
> How can I do it? How make a formulae for this.
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Excel" <[email protected]> wrote in message
news:[email protected]...
> I want to get the words for digits...eg. If I enter 4526 in a column , i
need
> to get "four thousand five hundred twenty six" in another column
> automatically.....
> How can I do it? How make a formulae for this.
The older reference is no longer available. (also applies to Bob's answer)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks