Conevrt Numbers to Words

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

Guest

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

Racer25 said:
Hi

I have to create a function/formula that will convert a number to words
Click to expand...
and being Europena we do things differently.
I see that most examples I have found on the web represent 12010.00 as
Click to expand...
Twelve Thousand Ten Dollar and No Cent in the UK we would represent this as
Twelve Thousand and Ten Euro Only.
 
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"



Racer25 said:
Hi

I have to create a function/formula that will convert a number to words
Click to expand...
and being Europena we do things differently.
I see that most examples I have found on the web represent 12010.00 as
Click to expand...
Twelve Thousand Ten Dollar and No Cent in the UK we would represent this as
Twelve Thousand and Ten Euro Only.
 
(...)
By the way, in the UK it would be represented as Twelve Thousand and Ten
Pounds Only
Click to expand...

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

Best wishes Harald
 
Back
Top