LinkBack URL
About LinkBacks
Hi everyone,
What is the VBA code for converting percentage value to English Word.
Example:
85.51 = Eighty Five point Fifty One Percent
91.00 = Ninety One Percent
7.11 = Seven point Eleven Percent
Thank you in advance
Hi everyone,
What is the VBA code for converting percentage value to English Word.
Example:
85.51 = Eighty Five point Fifty One Percent
91.00 = Ninety One Percent
7.11 = Seven point Eleven Percent
Thank you in advance
Last edited by chergian; 03-15-2017 at 04:57 AM.
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Originally Posted by karedog
Maybe :
Please Login or Register to view this content.
Thank you so much karedog.... But there are something wrong with .01 to .09, it's spell this way:
Example:
90.01 spell as "Ninety point One Percent" - instead "Ninety point Zero One Percent"
90.02 spell as "Ninety point Two Percent" - instead "Ninety point Zero Two Percent"
...and up to .09...
Hope you get my point...
Replace the F_percent() function above with this :
And don't forget to mark this thread as solved :Please Login or Register to view this content.
select Thread Tools from the menu link above and mark this thread as SOLVED.
replace the f_percent() function above with this :
and don't forget to mark this thread as solved :Please Login or Register to view this content.
Select thread tools from the menu link above and mark this thread as solved.
thank so much karedog... It works!
You are welcome, thanks for marking the thread as solved and for the rep.points.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks