How can I this???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shakeel Ahmad - 30 Apr 2007 13:43 GMT

I want a function on my Excel sheet.

If in Column A i have a list of amounts (in figures i.e. 15000 or 12450 or
56811 etc.), in the Column B it should write the same amount in words.

for Example:

A B
-- --

15000 Fifteen Thousant
12450 Twelve Thousant, Four
Hundred and Fifty
etc..............

Signature

Best Regards

Shakeel Ahmad

shakeel.ahmad215@gmail.com
www.groups.yahoo.com/group/islam-the-final-truth
www.geocities.com/shakeelahmad_79

Reply to this Message

Don Guillett - 30 Apr 2007 14:08 GMT

http://tinyurl.com/25cerg

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I want a function on my Excel sheet.
>
[quoted text clipped - 10 lines]
> Hundred and Fifty
> etc..............

Reply to this Message

Bob Phillips - 30 Apr 2007 14:27 GMT

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

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I want a function on my Excel sheet.
>
[quoted text clipped - 10 lines]
> Hundred and Fifty
> etc..............

Reply to this Message

Bernard Liengme - 30 Apr 2007 15:13 GMT

Numbers to words
Bob Phillips' site for help on this.

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

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

or

http://www.ozgrid.com/VBA/ValueToWords.htm

or

http://support.microsoft.com/?kbid=213360

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I want a function on my Excel sheet.
>
[quoted text clipped - 10 lines]
> Hundred and Fifty
> etc..............

Reply to this Message

Rate this thread: