I want to convert a number to text and the cents will appear as fraction.
e.g. 150.50 = ONE HUNDRED FIFTY AND 50/100 ONLY
150.00 = ONE HUNDRED FIFTY ONLY
I'm using this on making checks because it requires figures and in words.
If someone knows this pls help.
Make use of NB.TEXT function of Morefunc addin. Do a google search for getting the Morefunc Addin.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
In the link below is a simular question with an UDF solution.
http://www.excelforum.com/excel-prog...ers-excel.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I already know that but i want it to appear the the cents as fraction..
example : 150.50 = ONE HUNDRED FIFTY DOLLORS AND 50/100 ONLY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks