Numbers as Words

  • Thread starter Thread starter Darin
  • Start date Start date
D

Darin

Is there something in windows that will take a given set of numbers and
re-write them as words - such as for a check?

A friend wrote this macro for Excel and I didn't know if this was
something that could be written in VB.NET without excel.


Declare Sub Recibo Lib "dlltcast.dll" (cifra As Long, ByVal _
texto As String)

Function letras(minumero)

Dim texto As String * 255
Dim cifra As Long

texto = String(255, 0)
cifra = CLng(minumero)

Call Recibo(cifra, texto)

letras = texto

End Function

Darin
 
Darin,

Peter Huang showed us this page some years ago it is VB6 however almost
VBNET

Cor
 
Is there something in windows that will take a given set of numbers and
re-write them as words - such as for a check?

A friend wrote this macro for Excel and I didn't know if this was
something that could be written in VB.NET without excel.

Declare Sub Recibo Lib "dlltcast.dll" (cifra As Long, ByVal _
texto As String)

Function letras(minumero)

Dim texto As String * 255
Dim cifra As Long

texto = String(255, 0)
cifra = CLng(minumero)

Call Recibo(cifra, texto)

letras = texto

End Function

Darin
Click to expand...

FYI if you need this for a Crystal Report, there is a function that will do
this for you
 
I will have to look at the internal stuff since I already have this
working for english, but I need it in spanish, which writes their
numbers completely different.

Darin
 
Darin said:
I will have to look at the internal stuff since I already have this
working for english, but I need it in spanish, which writes their
numbers completely different.
Click to expand...
Hello Darin,

I found this site: <http://www.sf.airnet.ne.jp/~ts/language/number.html>
May be helpful for internationalization.

The English wikipedia stops with 10
<http://en.wikipedia.org/wiki/List_of_numbers_in_various_languages>

The German one has less languages but 0-19, 20..100,
1000, 10.000, 100.000, 1.000.000, 1.000.000.000, 1.000.000.000.000
<http://de.wikipedia.org/wiki/Zahlen_in_unterschiedlichen_Sprachen>
 
Back
Top