Log In
Register
Home
December 24, 2018
Offline
Hi everyone
may hope you all will be well
kindly guide me about the formula or method for converting digits in words, such as " 1,234 in words = one thousand two hundred thirty four only" in excel if there is a vba code for this, please send it
See Answer
October 5, 2010
Offline
Hi Salim,
Please read this post and use the code from it
https://www.myonlinetraininghu.....-excel-vba
Regards
Phil
Answers Post
December 24, 2018
Offline
Hi Sir Philip Treacy
Thanks for guide, there is a request regards this how can i add word "only" in this, i mean if i want to add only in last for example (one thousand five hundred dollar and no cent only ) please guide me
October 5, 2010
Offline
Hi Salim,
Concatenate " only" to result the function returns:
=numtowords(A2) & " only"
Regards
Phil
VIP
Trusted Members
June 25, 2016
Offline
Hi Salim
To add to Phil's reply, you can also use SUBSTITUTE(numtowords(A2) & " only","dollars","euro"), for example.
It will replace the dollar to whatever currency (euro, in this example) that you are using.
Sunny
December 24, 2018
Offline
Dear Sir Philip
is there any method of adding word "only" by using vba code, it will be easy and good then adding ( =numtoword()&"only"), by using formula =numtoword()
Regards
Salim
October 5, 2010
Offline
Sure,
Open the VBA editor and modify the last line of the NumToWords function to this
NumToWords = Application.Trim(Units & SubUnits) & " only"
Regards
Phil
1 Guest(s)
