Any method of formatting a cell that will return a number value with pronounceable text. cell contains "53,768" cell would return "fifty-three thousand, seven-hundred and sixty-eight".

Convert numbers into words - Excel

Thanks. I will give it a go.

getting an error from this line


Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))

Not certain what would cause the error. I've run the code here and it works fine.

Perhaps post your workbook ?

I guess I need to learn MSVB.

Post your workbook without confidential information ... I'll look at it for you.

Fairly new here. Not sure where to upload a file after starting a post.

Down below where you write your messages ... click on GO ADVANCED. Look around after that to see about attaching a file.

Found it. It is a macro enabled workbook.

Attached Files

deaths.xlsm (18.8 KB, 5 views)

The original code from the website had two lines (the one you mentioned and another one further down) that were using the "underscore" symbol. That allows a line of code to be broken down into shorter lengths so the entire line can be visible to the coder when writing the code. Otherwise, some lines of code would extend far off to the right side of the coding window and make it difficult to view.

In any case, the corrected version is attached.

You can experiment with the code to get rid of the "Cents" and "Dollars" so all you are left with is the number itself.

Might want to experiment with a copy of the file so you don't mess up the original one.

Cheers and stay healthy !

Attached Files

deaths.xlsm (20.4 KB, 5 views)

Sweet. Thanks!

You are welcome. Stay healthy !