Converting Numbers to Text

[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.

 

[Bob Phillips]

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)

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.

 

[Jason Morin]

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

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.

 

[Andy Wiggins]

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"

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.