convert number to english word

**mimzkie1101** · 09-10-2012, 02:19 AM

i copy the spellnumber vba code for converting number to words. ex. 2,500.23 two thousand five hundred dollar and twenty three cents only.. i want the result should be 2,500.23 two thousand five hundred dollar and 23/100... what should be the code for this.???
please help me with this..

**zbor** · 09-10-2012, 02:26 AM

change decimal result to decimal&"/100"

**mimzkie1101** · 09-10-2012, 05:10 AM

do i need to define a value for this so that the decimal value will be converted to fraction??

**zbor** · 09-10-2012, 05:41 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here