Is there any readymade function or utility in Excel or
Word to write a number into words?
e.g. show 1418 as : One Thousand Four Hundred Eighteen.
Is there any readymade function or utility in Excel or
Word to write a number into words?
e.g. show 1418 as : One Thousand Four Hundred Eighteen.
Excel help has instructions
"Sunil S Gawde (INDIA)" <[email protected]> wrote in message
news:[email protected]...
> Is there any readymade function or utility in Excel or
> Word to write a number into words?
>
> e.g. show 1418 as : One Thousand Four Hundred Eighteen.
>
>
Yes.
http://exceltips.vitalnews.com/Pages...elled_Out.html
/Fredrik
On Thu, 7 Apr 2005 12:56:53 -0700, "Sunil S Gawde \(INDIA\)"
<[email protected]> wrote:
>Is there any readymade function or utility in Excel or
>Word to write a number into words?
>
>e.g. show 1418 as : One Thousand Four Hundred Eighteen.
>
Longre's morefunc.xll add-in has this and many other useful functions:
http://xcell05.free.fr
(He has English and French language versions of this add-in).
--ron
Hi Sunil,
You can download one add-ins Indian Rupees from below site
http://members.lycos.co.uk/shahweb/
1. to convert number into Indian Rupees in Words.
2. to convert number format to Indian Decimal System.
Regards,
Shailesh Shah
"Sunil S Gawde (INDIA)" wrote:
> Is there any readymade function or utility in Excel or
> Word to write a number into words?
>
> e.g. show 1418 as : One Thousand Four Hundred Eighteen.
>
>
>
For this one, i actually wrote my own series of formulae (mainly because I didnt know the answer was out there already).
Because it's all formulae, it doesnt need any macros (and therefore the need to mess about with Security for enabling them) and also it doesnt rely on any add-ins either, meaning it can be run on any Excel set-up... particularly useful if sharing your workbooks to a large audience over a network, you just hide the columns and lock the sheet.
If anyone's interested, PM me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks