How do i convert number to wording

[Mohammad Irfan]

How can i convert number to wording in ms excel
for example 1,100 = One Thousnad One Hundred.

I there any function or method by which i can
convert number to wording.

[Paul B]

Mohammad, have a look here,

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


Also see here
http://support.microsoft.com/default...;EN-US;Q213360


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mohammad Irfan" <Mohammad Irfan@discussions.microsoft.com> wrote in message
news:3E73F956-02F4-4540-BD65-EB360AC94E8C@microsoft.com...
> How can i convert number to wording in ms excel
> for example 1,100 = One Thousnad One Hundred.
>
> I there any function or method by which i can
> convert number to wording.

[Mangesh Yadav]

http://groups-beta.google.com/group/...gramming/brows
e_thread/thread/67a8380dafcea636/d0cc1286d078593c?q=convert+number+to+words&
rnum=1&hl=en#d0cc1286d078593c

http://groups-beta.google.com/group/...gramming/brows
e_thread/thread/fdea2eca87d4e308/20a90d9742f650c2?q=convert+number+to+words&
rnum=2&hl=en#20a90d9742f650c2

http://www.mvps.org/dmcritchie/excel/strings.htm



Mangesh



"Mohammad Irfan" <Mohammad Irfan@discussions.microsoft.com> wrote in message
news:3E73F956-02F4-4540-BD65-EB360AC94E8C@microsoft.com...
> How can i convert number to wording in ms excel
> for example 1,100 = One Thousnad One Hundred.
>
> I there any function or method by which i can
> convert number to wording.