Convert a number to words in Excel

Good evening kaousow,

The question has already been asked on this site. Someone proposed a solution at the following address:

https://forums.commentcamarche.net/forum/affich-453489-vb6-conversion-chiffres-lettres

This solution works, but has some imperfections (for example: "seventy ten four" instead of "seventy-four", and a few agreement mistakes).

Personally, I've created one that accepts 3 parameters:
- the number to convert, of course,
- the currency (Euro by default)
- uppercase or lowercase (uppercase by default)

If the one you find on this site suits you, fine.
Otherwise, let me know at my username at free.fr.

Armojax.

A Mahay be
How to convert a number (25,045.57 Euros or dollars for example) into words

Hello,

I also downloaded this macro, but the problem is that I want to use a currency other than € or $ (CFA Franc). Is there a way to bypass the formula to include text afterwards?

Hello,

I would like to know if someone has the code in Windev to convert a sum into words. Thank you in advance.

Sanini
you tell me that it is not locked yet I press alt F11 and when I try to enter it asks me for a password could you help me

thank you in advance

Hello,
thank you for letting me know how to convert a number in EXCEL 7 into words but in a different column?
thank you for your help.
I am counting on you.
Best regards,
Eve

You don't need to switch to text, you can simply replace dollar with CFA francs in the Visual Basic code. I did it and it works. After launching your Excel, you press ALT F11; the code is not locked. This is if, like me, you're not good at programming, otherwise you can just add a CFA francs currency. By the way, thanks to e_amin_e for this macro.

820 045

You will find the answer to your question at the following link:

http://www.01net.com/outils/telecharger/windows/Bureautique/tableur/fiches/tele32813.html

Otherwise, look for the utility Morefunc.

Thank you
this link to download the Excel sheet or the macro:
http://intranet.greta65.com/espace_stagiaires/trucs_astuces/NumText_SVM-GRETA/index.htm

Pour convertir le chiffre 198457,98 en lettres, cela donnerait :

« cent quatre-vingt-dix-huit mille quatre cent cinquante-sept euros et quatre-vingt-dix-huit centimes ».

Hello kaousow

I don't quite understand your question..
Do you want to create a function that allows you to display a number in words regardless of what it is?..
If so, there are infinite possible combinations.. I don't know if it's feasible..

Fanou

<translation> Hello, I need help to create a formula that will convert certain numbers into letters.

Let me explain: conversion to base 36: from 0 to 9 it stays the same, but from 10 to 35 it should become A to Z (10 = A, 35 = Z).
After that, for 36 we have 10 (1 x 36), then for 37 we have 11 (1 x 36 + 1), then for 38 we have 12 (1 x 36 + 2), then for 39 we have 13 (1 x 36 + 3), then for 40 we have 14 (1 x 36 + 4), then for 45 we have 19 (1 x 36 + 9 = 45), then for 46 we have 1a (1 x 36 + 10 = 46) [because in base 36, as soon as we go over 9, we switch to letters]. Then for 71 we have 1z (1 x 36 + 35 = 71), then for 72 we have 20 (2 x 36), then for 73 we have 21 (2 x 36 + 1), then for 81 we have 29 (2 x 36 + 9), then for 82 we have 2a (2 x 36 + 10) (when we go over 9, we start using letters, then after Z it becomes 10, and so on).

Is there anyone who could create a formula for me, please? This is beyond my skills. </translation>