dollar function

[dpal]

Could you give me the formula to change a dollar cell
format into a word written format.
EX: $100

Formated to: One Hundred Dollars and oo cents.

Thank YOu

 

[Frank Kabel]

Hi
Try doing a Google search and you'll find many macros/procedures to
convert numbers to text. Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
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

 

[Dave R.]

Side note- I have attempted to use Longre's UDF, and it does not work for me
with XL 2003. Tho it did work in 2000.

I emailed him about it a few week ago but that was the end of it.

 

[Frank Kabel]

Hi Dave
I'm also using Excel 2003 (German version) and have no problems using
this UDF

 

[Dave R.]

For me, =NBTEXT(8019) returns one character -- an a with an accent -- which
is CHAR(224).

I have tried various arguments in it, and it even gets to the point of
crashing Excel if I push it too hard.

Any idea what could be causing that?

 

[Dave R.]

I just searched the archives and it looks like others have had that problem
too.

 

[Frank Kabel]

Hi
what does
=NBTEXT(8019,2)
return?

 

[Dave R.]

Still returns a CHAR 224.

The other posts I've seen on this say it's not necessarily related to
version. One was from an MVP who couldn't get NBTEXT to work on anything
from 97-up.

 

[Frank Kabel]

Hi
interesting. So this is an issue for Laurent