Number to text conversion in excel 2000

[cyberdyne]

Hi !

I am not a regular user of excel. More into hardware.
I have excel 2000.
Here I need to convet a sum of few numbers into text.

Example:
A B
1 10100
2 20050
3 30005
4 Total 60155
5 Total in words: SIXTY THOUSAND ONE HUNDRED FIFTY FIVE

Can any one help me ?

thanks

regards

Apoorva
An uses

What solution I give is according to best of my knowledge and the information / feedback that you provide. So tell us more and we can lead you to right direction.
Internet is a tool respect it and use it for human wellfair.

 

[KenWright]

Try:

XL2000: How to Convert a Numeric Value into English Words

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&

and:

XL: How to Convert a Numeric Value into English Words

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q140704&

and:

(courtesy of a cut and paste from a Tom Ogilvy post):

If you want an addin that provides a worksheet function that does this,
download Laurent Longre's free morefunc.xll addin found here:

http://longre.free.fr/english/

It is downloaded in a zip file which also contains an informative file in
'hlp' format that describes the 33 or so very useful functions included, one
of which does the number to words conversion you describe (supports various
languages and currencies).


and:
(Courtesy of Andy Wiggins FCCA) of

http://www.BygSoftware.com

This file might be a help:

http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:

http://www.bygsoftware.com/examples/examples.htm

It contains two methods to convert numbers to words and two check writing
routines.

The code is open and commented.

And, finally:

http://groups.google.com/groups?as_umsgid=3B682245.F7B58BAF@consumer.org

A post containing a UDF by Bernie Deitrick that will take you into US budget
territory by covering amounts into trillions.

Regards
Ken..................


----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[cyberdyne]

KenWright

Thanks alot. This is exactly I wanted.

One little more question. I used microsoft code and it is working nice. But it is limited to that perticular file only. Is there any way that I can have this function availabel in each new file that I open ?

To tell you the whole story, I am making my invoices in excel. What I am doing is making a seperate file for each bill. Now this function is good for the file in which I paste the code. I need something like a word templete (.dot) file so that I open one file and save it in another. is it possible ? Or you have some batter Idea ? In this method I face a problem to remember the last invoice no. or I have to open that file and see. How can I have auto increment of invoice no ? I tried to use excel wizard to create invoice system which comes with it. But the format given is very different to what I am using.

Any ideas pls drop a line.
Thanks once again.

Apoorva



regards

Apoorva
An uses

What solution I give is according to best of my knowledge and the information / feedback that you provide. So tell us more and we can lead you to right direction.
Internet is a tool respect it and use it for human wellfair.

 

[Dreamboat]

File-->Save as-->Template (*.xlt)

To create a new invoice from template, hit File-New and double-click the template.



Anne Troy