General discussion

Locked

Convert from numbers to letters in excel

By mariofp ·
How can I convert from numbers i.e.: $100.00 to letters. i.e.: one hundred dollars and zero cents.
Can I do it in two different cells (one for the number and other for the letters)?
Can that be done in other languages?
Thanks.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Convert from numbers to letters in excel

by shmaltz In reply to Convert from numbers to l ...

You should use VBA.

Collapse -

Convert from numbers to letters in excel

by mariofp In reply to Convert from numbers to l ...

Poster rated this answer

Collapse -

Convert from numbers to letters in excel

by Zalog In reply to Convert from numbers to l ...

This is the classic check example. For this example I have limited the max amount to $9999.99, but simple modifications can increase this limit.

1. Create a table with the values from 1 to 99 in the first column and the text representations inthe second column. I named this range Words.

2. Compute the integer value of the check amount divided by 1000. =int(CheckAmt/1000) Call this Thousand.

3. Now use the vlookup function for the result to get the text word. =vlookup(Thousand, Words, 2)

4. Append "Thousand" to this value.

5. Subtract Thousand from CheckAmt and use this value as your new starting point. Repeat steps 2-5 for Hundreds and Tens.

6. You will be left with cents. I just made this to be xx/100.
7. String all the text values together.

I have an example worksheet if you would like me to email it to you.

Collapse -

Convert from numbers to letters in excel

by mariofp In reply to Convert from numbers to l ...

Thanks, I really want to see that example worksheet.
mariofp@usa.net

This answer really helped!
Thanks again.

Collapse -

Convert from numbers to letters in excel

by mariofp In reply to Convert from numbers to l ...

JC Zalog:
I really want to see that example.
It is safe to write here my email?
Thanks.

Collapse -

Convert from numbers to letters in excel

by mariofp In reply to Convert from numbers to l ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Software Forums