Conevrt Numbers to Words

[Racer25]

Hi

I have to create a function/formula that will convert a number to words and being Europena we do things differently.

I see that most examples I have found on the web represent 12010.00 as Twelve Thousand Ten Dollar and No Cent in the UK we would represent this as Twelve Thousand and Ten Euro Only.

Your help would be appreciated.

Thanks

Rob

 

[Harald Staff]

Hi Rob

Laurent Longre has a great thing for this at
http://longre.free.fr/english/
including "NBTEXT converts a positive number into spelled-out text (supports
13 languages)". It considers lots of european specialities, like the
German/Danish "one-and-twenty" counting style. Not sure about the "Only"
part though.

Or you can modify this to fit your needs:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360

--
HTH. Best wishes Harald
Followup to newsgroup only please

Hi

I have to create a function/formula that will convert a number to words

and being Europena we do things differently.

I see that most examples I have found on the web represent 12010.00 as

Twelve Thousand Ten Dollar and No Cent in the UK we would represent this as
Twelve Thousand and Ten Euro Only.

 

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

By the way, in the UK it would be represented as Twelve Thousand and Ten
Pounds Only (unless Gordon announced something in the last hour I haven't
heard about)..
--

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

Hi

I have to create a function/formula that will convert a number to words

and being Europena we do things differently.

I see that most examples I have found on the web represent 12010.00 as

Twelve Thousand Ten Dollar and No Cent in the UK we would represent this as
Twelve Thousand and Ten Euro Only.

 

[Harald Staff]

(...)

By the way, in the UK it would be represented as Twelve Thousand and Ten
Pounds Only

"Only" ? Looks expensive enough to a middle class norwegian <g>

Best wishes Harald

 

[Andy Wiggins]

Hi Harald,

"Only" is a legal thing

--

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