Hello,
I'm asking little help with this excel sheet
I'm trying to insert number in a cell (in my case in cell G5), and I want this number to be in letter in cell D8 using not USD but SDG unit
Thank for help.
Attached file.
Hello,
I'm asking little help with this excel sheet
I'm trying to insert number in a cell (in my case in cell G5), and I want this number to be in letter in cell D8 using not USD but SDG unit
Thank for help.
Attached file.
Do you mean.. something like..
Ten Singapore Dollar instead SGD 10
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
yes SDG 10
See the attached file with an UDF.
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.
it works but in cell number D8 it show in dollars not sdg!!!!!
For that (Singapore Dollar) see this file.
mm yep
If you can do it using SDG in place of Singapore Dollars
Many thanks for your help
See version 3.
Please reply if this is what you're up to.
In D8.. instead of spellnumber(G5) use...
=UPPER(spellnumber(G5))
@rami10
You were very quick on your earlier replies.
Please also reply on my last solution.
Big thanks oeldere
Yes that's what I'm Asking For but Please if you can delete the cents from the spelling.
Thanks for your help
Big thanks oeldere
Yes that's what I'm Asking For but Please if you can delete the cents from the spelling.
Thanks for your help
See the attached file.
Please reply if this is what you want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks