Quizzes & Puzzles2 mins ago
Is There An Excel Formula Or Function Can I Use To Convert South African Currency (Rand) To Text, E.g. R235.40 (Two Hundred Thirty Five Rands And Forty Cents)?
8 Answers
I'm using Microsoft Office Home & Student 2016 on a laptop running Windows 10 Home, 64-bit.
I googled above question but didn't get anywhere..... the resulting solutions wouldn't work.
I googled above question but didn't get anywhere..... the resulting solutions wouldn't work.
Answers
1 to 8 of 8
Best Answer
No best answer has yet been selected by rhythmcrazy. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
It's possible but not particularly simple:
https:/
Note that the method there won't, on its own, separate rands from cents. (i.e. you'll end up with 'two hundred and thirty five point four zero rands'). To achieve that you'd first need to separate the two parts by using the integer function. (i.e. use the integer function to get 235 rand, then subtract that from the original figure and multiply by 100 to give you the 40 cents before converting each part separately to words).
https:/
Note that the method there won't, on its own, separate rands from cents. (i.e. you'll end up with 'two hundred and thirty five point four zero rands'). To achieve that you'd first need to separate the two parts by using the integer function. (i.e. use the integer function to get 235 rand, then subtract that from the original figure and multiply by 100 to give you the 40 cents before converting each part separately to words).
oh I see now, sorry. Ok some programming needed, VB macro can do it. You'll probably find a pre written one on the net. see here:
https:/
https:/
doesnt the TEXT fnction do this?
https:/
if you say no then I understand why I have crashed the crippy AAT level 3 spreadsheet exam no less than four times
https:/
if you say no then I understand why I have crashed the crippy AAT level 3 spreadsheet exam no less than four times
1 to 8 of 8
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.