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.
12-19-2019 10:39 AM
12-23-2019 12:20 AM
In the attached file I need to enter the month in the first tab where I have highlighted which should pick the month in second tab and post the total from the third tab to the second tab in the appropriate month.
Can you help me please?
12-23-2019 08:01 AM - edited 12-23-2019 08:08 AM
You need to post this as the start of a new thread. It is not a continuation of the existing conversation....
However, now that I've taken a few minutes to look at that workbook, I would suggest you go back to whoever it was that designed it and ask for clarification (and fixes) there. It's clearly meant as a template for personal cash flow management, but is not fully functional at this point (unless you inadvertently made changes to it that adversely affected it).
05-03-2020 04:41 AM
I'll get help. I hope you help me (although I know I'm at the computer level). I'm not ashamed of my ignorance. Because really: "The world is full of opposites.".
I only do Excel calculations for myself. I have a problem with one calculation. Specifically: the same numbers, but the same function, but the result is different in both equivalent calculations. If only I knew what the correct function must be to get the right result (and it's the same number in both identical operations). I will send you a file (Microsoft Office Home and Student 2013). Will you send me back the correct formula.
I watched the "Excel NumToWords Formula" level. I saved your NumWords.xlsx file. The function works! How, I do not understand… but I say only to myself: I am learning!
05-03-2020 06:45 AM