![]() The second is for general use and will convert the number to a string of words. I've created two workbooks that you can use. (period or full stop) and some use, (comma). My code allows you to specify what currency you use, and it takes into account regional variations of the decimal separator. ![]() Microsoft does provide some VBA code which I will use as my starting point, and I have seen other examples, but these examples only allow for one currency. ![]() Excel doesn’t provide a function to do this so I’m going to write my own. 123.45 becomes One Hundred Twenty Three Dollars and Forty Five Cents. We get requests now and again asking how to convert numbers to words (or convert currency) e.g.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |