dollar function

  • Thread starter Thread starter dpal
  • Start date Start date
D

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
 
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
 
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.
 
Hi Dave
I'm also using Excel 2003 (German version) and have no problems using
this UDF
 
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?
 
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.
 
Back
Top