hi
pls help me with the formula to convert amount in cell to words like it shows sometimes on commercial invoices
thanks
raj
hi
pls help me with the formula to convert amount in cell to words like it shows sometimes on commercial invoices
thanks
raj
http://www.meadinkent.co.uk/xlnumberstext.htm
This Web Site has the function you request
once you have copied and pasted the code into a module, the formula will be =WordNum(A1) if your value is in A1
Raj, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
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
"Raj Shah" <[email protected]> wrote in
message news:[email protected]...
>
> hi
> pls help me with the formula to convert amount in cell to words like it
> shows sometimes on commercial invoices
> thanks
> raj
>
>
> --
> Raj Shah
> ------------------------------------------------------------------------
> Raj Shah's Profile:
http://www.excelforum.com/member.php...o&userid=27505
> View this thread: http://www.excelforum.com/showthread...hreadid=534075
>
many thanks
raj
Originally Posted by davesexcel
many thanks
raj
Originally Posted by Paul B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks