tag:blogger.com,1999:blog-9312542.post883986030658476116..comments2023-04-28T02:41:27.619-07:00Comments on Excel Formulas: Formula for Converting Dollar Amount to WordsJon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-9312542.post-22011677835286627152016-08-05T07:31:33.742-07:002016-08-05T07:31:33.742-07:00This the material I have been searching for severa...This the material I have been searching for several days. Convert number to word without vba. I beg you permite me to take some point from this article as a reference for my blog. Many ThanksBelajar Excelhttp://je-xcel.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-9312542.post-69510940269754950352016-01-03T17:50:22.191-07:002016-01-03T17:50:22.191-07:00Thanks for this time saver!Thanks for this time saver!Anonymoushttps://www.blogger.com/profile/08835025631512463489noreply@blogger.comtag:blogger.com,1999:blog-9312542.post-88782501599804524982012-03-09T21:33:09.613-07:002012-03-09T21:33:09.613-07:00"21" and "21000" bug fixed: Ch..."21" and "21000" bug fixed: Changed [>1, "-"] to [>=1, "-"] and [>1000, "-"] to [>=1000, "-"]Jon Wittwerhttps://www.blogger.com/profile/04461947852006005549noreply@blogger.comtag:blogger.com,1999:blog-9312542.post-85380749991419581582011-07-21T07:25:22.766-07:002011-07-21T07:25:22.766-07:00There appears to be a glitch in the formula, where...There appears to be a glitch in the formula, wherein certain numbers that end in 21, 31, 41, 51, 61, 71, 81, or 91; appears in the formula result as twenty, thirty, forty, fifty, sixty, seventy, eighty and ninety (missing the “one”).<br /><br />By example: 571.00 <br /><br />Appears as: Five Hundred Seventy and NO/100 Dollars<br /><br />My Excel version is 2007 on a PC…<br /><br />Any advise --Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312542.post-56687826199325799212011-05-17T09:00:48.288-07:002011-05-17T09:00:48.288-07:00Creative formula. I love that you figured out how...Creative formula. I love that you figured out how to do it without using VBA. I'll definitely be using this idea.Outsource Excelhttp://outsourceexcel.comnoreply@blogger.comtag:blogger.com,1999:blog-9312542.post-2044329210611279862011-03-13T07:21:47.786-07:002011-03-13T07:21:47.786-07:00Wow, thank your tips excel.Wow, thank your tips excel.xclmediahttp://xclmedia.comnoreply@blogger.com