06-27-2019 10:59 PM
07-11-2019 12:00 AM
Thanks for your compliment. Incidentally, you need not copy the workbook. You only have to copy the formula to any cell other than those in Column A and it will convert the number to its left to words.
Thereafter, you can convert any number in the same workbook by entering this formula in the cell to its right:
12-17-2019 12:18 AM
12-18-2019 12:51 PM
12-18-2019 03:24 PM
That's great. And congratulations on your twentieth week! I think I'm in my fourth or fifth, and loving it too.
Your formula here takes me back to my earliest days with a PC...probably the late 70s.. I wrote a program (Basic) to print checks to pay bills; got a supply of checks that would go through a pin-feed, dot matrix Okidata printer.
And I wrote a routine that would translate 123.45 into "One Hundred Twenty-Three Dollars and Forty-five Cents" One feature of which I was very proud was that if the amount was, say, 1.14, the words would be "One Dollar" --- in the singular-- and same for "One Cent" if it came to that. None of that settling for "Dollars" just because that 99.9% of the time would work accurately. I notice you left off the currency label, which makes it more universal, so no problem.
But fun, right?
Thanks for sharing it.
12-18-2019 08:51 PM
Thanks for your compliment. My formula is universal, such that, as its name connotes, it converts a number to words, not to a specific currency. You're right, it was fun constructing the formula.
By the way, the formula is broken down into components to enable modification of each to convert a number to a specific currency.
12-18-2019 09:18 PM
12-18-2019 10:26 PM - edited 06-19-2020 05:36 PM
My NumToWords is a named formula, not a built-in function. You must copy B2 of my worksheet to B2 of yours to store the named formula into your Name Manager. Without copying B2, NumToWords won't work in your worksheet because it is not stored in your Name Manager.
12-19-2019 12:39 AM
Your story inspired me to modify my NumToWords formula to consider Dollars as a currency built into it. The integer portion is described as either "Dollar" for singular or "Dollars" for plural. Conversely, the decimal portion is described as either "Cent" for singular and "Cents" for plural.
To test its accuracy, I entered my NumToDollars formula in Column B, as shown here:
As with my NumToWords, my NumToDollars can also convert any value up to 15 significant digits. Moreover, NumToDollars can be easily converted to apply to another Currency by modifying its components.