spellnumber for 1-10 only without dollars or any currency ?
spellnumber for 1-10 only without dollars or any currency ?
I assume you are referring to the SPELLNUMBER example UDF?
Can't you just cut out the CASE Selects "Dollar" and "Cents"?
Well, if you're just returning integer text names between one and ten, I would just run a CHOOSE off the input and be done with it:
Please Login or Register to view this content.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
I tried the code but It didnt work.
Can u send edited code for the same ?
I think you need to give a bit more detail regarding what you want here?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
HI,
Spellnumber should work if you just cut out all the text.
Below you can find the full code for the Custom Function
good luck
This is the code:
Please Login or Register to view this content.
Last edited by FDibbins; 11-26-2015 at 03:51 AM.
Jan Van der Borght Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
I have added them for you - this time
@FDibbins,
Tnx yr help. I'm new to this forum and wasn't aware.
rgds
jan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks