I would like to take a number field in one cell and in another cell have the
it in words. For example in cell A1 = 1550 while in cell A2 it says ONE
THOUSAND FIVE HUNDRED AND FIFTY

Is there any way to do this???? Plz Help. Thanks in advance.

mr_bsh, 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


"mr_bsh" wrote in message
...
I would like to take a number field in one cell and in another cell have
the
it in words. For example in cell A1 = 1550 while in cell A2 it says ONE
THOUSAND FIVE HUNDRED AND FIFTY

Is there any way to do this???? Plz Help. Thanks in advance.

No built-in Function, but you can build your own User Defined Function using
the info at:

http://support.microsoft.com/default...;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from he

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

With either these two Functions the setup would be....enter the number(456) in
A1. In B1 enter =FunctionName(A1)

The KB article names their Function SpellNumber

Laurent's is NUMTEXT


Gord Dibben Excel MVP

On Mon, 9 May 2005 11:13:18 -0700, mr_bsh
wrote:

I would like to take a number field in one cell and in another cell have the
it in words. For example in cell A1 = 1550 while in cell A2 it says ONE
THOUSAND FIVE HUNDRED AND FIFTY

Is there any way to do this???? Plz Help. Thanks in advance.

On Mon, 09 May 2005 11:57:57 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Laurent's is NUMTEXT

NBTEXT in the english version of his current release, I think.


--ron

This file might be a help:
http://www.bygsoftware.com/examples/...s/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 cheque writing
routines.

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"mr_bsh" wrote in message
...
I would like to take a number field in one cell and in another cell have
the
it in words. For example in cell A1 = 1550 while in cell A2 it says ONE
THOUSAND FIVE HUNDRED AND FIFTY

Is there any way to do this???? Plz Help. Thanks in advance.

Correct Ron.

Must update my posting archives.

Way behind on Laurent's MOREFUNC version.


Gord

On Mon, 09 May 2005 21:19:19 -0400, Ron Rosenfeld
wrote:

On Mon, 09 May 2005 11:57:57 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Laurent's is NUMTEXT

NBTEXT in the english version of his current release, I think.


--ron