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)?

[rhythmcrazy]

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.

[Buenchico]

It's possible but not particularly simple:
https://support.office.com/en-us/article/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98

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).

[ToraToraTora]

just use format cell to tell it what the data type is. Not sure I understand the problem.

[ToraToraTora]

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://www.myonlinetraininghub.com/convert-numbers-currency-to-words-with-excel-vba

[Peter Pedant]

doesnt the TEXT fnction do this?
https://exceljet.net/excel-functions/excel-text-function

if you say no then I understand why I have crashed the crippy AAT level 3 spreadsheet exam no less than four times

[ToraToraTora]

pee pee, no that's to make a number text not convert it to words. I think the OP wants to convert a number into what it would be in words, eg 123 = "One hundred and twenty three".

[fiction-factory]

I'm curious to know why there would be a requirement to put a monetary figure in words

[rhythmcrazy]

Thanks everyone for your input - I approached a book keeper in the mean time and she supplied me with a long formula which does the job. Problem solved, thanks again.

[Zacs-Master]

There are many websites which will do it for you in an instant.