how to convert numbers to letters

[mounir_az]

hi.

i want to know how to convert numbers to lettres.

thank you in advance.

 

[Solitaire]

Please explain. What is the purpose of your program? What is the range of the numbers? Are the numbers single-digit or multi-digit? What kind of letter do you want to replace with each number?

 

[mounir_az]

Good morning

program with visual BASIC 2005, and numbers these are numbers decimals.

Thank you in advance

 

[Robert_Zenz]

Hello.

Are you looking for System.Convert.ToChar(yourNumberHere) or yourNumberHere.ToString() ?

Bobby

 

[mounir_az]

hi.
its not working.
are there fonction in crystal report to convert numbers to lettres.

 

[Solitaire]

Do you mean you want to convert an ASCII (or Unicode) value to a character? The following code will return the character "A":

Dim ch As String
Dim anum As Integer
anum = 65
ch = Chr(anum)

If this is not what you want, then you need to explain exactly what you are trying to do, and include some of your code.

 

[JuggaloBrotha]

You could try something like this

Dim Letters As String = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
Dim Letter As String = Letters(index)

 

[mounir_az]

Good evening,
I have a invoice in crystal report which posts the list of the products and the total sum of the products.

I want to convert this total of the amounts of the product into letter for to post into crystal report.

thank you in advance.

 

[Solitaire]

You mean you want to convert a number into a string? That's easy.

Dim num As Double
Dim snum As String
num = 456.73
snum = num.ToString

 

[anthony.selby]

Are you asking for numbers to a string ... or numbers to words

ie 10 = ten ?

 

[mounir_az]

yes for exemple 10 = ten

 

[anthony.selby]

here is a project on planetsourcecode (its in vb6) so you will have to update it to work ...

A Cheque (Check) Writing App - Numbers to Words by John Black

 

[mounir_az]

where is the project. the link dosen't work ?

 

[Solitaire]

What you want to do is spell out numbers using English words. That's what you should have explained in the first place.

There is no such "function" in any language. You need to do the grunt work yourself and come up with a lot of code for each digit and each place value. Start by converting the number to a string and extracting each character one by one. Then write several subprocedures to translate each character to a word, depending on its place value. Then you will need to concatenate the words to a string corresponding to the full number.

Do it little by little, starting with numbers up to 9, and then up to 99. By then, you should have the hang of it. Good luck.

 

[anthony.selby]

The link works for me ...