Hi All,
I need a formula for number to word without VBA code. My currency is Taka instead of Dollars and after decimal it's called Paisa instead of Cent. Also require the word Only, in the last.
Here is the sample for better understanding
1 = One Taka Only
10 = Ten Taka Only
10.50 = Ten Taka Fifty Paisa Only
100 = One Hundred Taka Only
1000 = One Thousand Taka Only
10000 = Ten Thousand Taka Only
100000 = One Lac Taka Only (We called Lac for one hundred thousand)
1000000 = Ten Lac Taka Only
10000000 = One Crore Taka Only
Please help me with this formula if anyone can able to do so.
Thanks in advance.
Bookmarks