Converting Numbers to Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function or another way to convert a numeric dollar amount into written text

I'd like a $1,809.34 to convert to One Thousand Eight Hundred Nine Dollars and 34/100

I can easily figure out the cents portion to add to the string with concatnate but the rest I was hoping there was already a function prepared.
 
Lyndon,

Laurent Longre's MOREFUNC.XLL , available at
http://longre.free.fr/english/index.html has a Numbers to Words Function
along with many other useful Functions.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Lyndon said:
Is there a function or another way to convert a numeric dollar amount into written text?

I'd like a $1,809.34 to convert to One Thousand Eight Hundred Nine Dollars and 34/100.

I can easily figure out the cents portion to add to the string with
Click to expand...
concatnate but the rest I was hoping there was already a function prepared.
 
You can download a free add-in called MOREFUNC.XLL by
Laurent Longre that has a host of useful functions,
including one to do exactly what you're requesting:

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

The function is NBTEXT.

HTH
Jason
Atlanta, GA
-----Original Message-----
Is there a function or another way to convert a numeric
Click to expand...
dollar amount into written text?
I'd like a $1,809.34 to convert to One Thousand Eight
Click to expand...
Hundred Nine Dollars and 34/100.
I can easily figure out the cents portion to add to the
Click to expand...
string with concatnate but the rest I was hoping there was
already a function prepared.
 
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 cheque writing
routines.

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Lyndon said:
Is there a function or another way to convert a numeric dollar amount into written text?

I'd like a $1,809.34 to convert to One Thousand Eight Hundred Nine Dollars and 34/100.

I can easily figure out the cents portion to add to the string with
Click to expand...
concatnate but the rest I was hoping there was already a function prepared.
 
Back
Top