Hi.
I would like a code to read the number in words and retonar numerical value.
example:
cell 'A2' = two hundred forty-five.
results in 'B2' = 245
Thank you!!
Hi.
I would like a code to read the number in words and retonar numerical value.
example:
cell 'A2' = two hundred forty-five.
results in 'B2' = 245
Thank you!!
Last edited by marreco; 10-06-2012 at 08:57 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
heres a link to Ron Coderre's Excel Sample template
http://www.contextures.com/NumsToWords_VBA.zip
Edit: Mis-read your post, I see you want word to number not number to word.
http://www.contextures.com/ExcelTemp...SampleFile.zip
Last edited by mike7952; 10-06-2012 at 08:21 AM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
If I'm not mistaken, this is Walkenbachs code. Please be aware that it adds dollars at the end.
edit: guess i had it the wrong way as well ^^
Please Login or Register to view this content.
If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks