Convert numbers to words

[kelly mort]

Hello,
I am stucked here again:

Can I ever convert numbers to words with a formula?


Say $12345 I will want to get twelve thousand three hundred and forty five. Thanks
Kelly

 

[kelly mort]

Just for a laugh really and probably doesn't cover all scenarios assumes the $ sign is there through formatting

Excel Workbook
	B	C
5	1374722595	One Billion Three Hundred And Seventy-Four Million Seven Hundred And Twenty-Two Thousand Five Hundred And Ninety-Five Dollars And Twenty-One Cents
6	112345	One Hundred And Twelve Thousand Three Hundred And Forty-Five Dollars
Sheet1

This is huge data!!!!

 

[MARK858]

This is huge data!!!!

Said it was for a laugh adjusted a formula by HaroonSid for someone who wasn't allowed to use VBA.

 

[MrIfOnly]

@MARK858:

 

[sanj_edu]

Also say a number like 4722595.21 the "and" between seven hundred then twenty two did not show. Anyway around this?
Kelly

If you have 4722595.21.
What is the end result you are expecting...

 

[kelly mort]

If you have 4722595.21.
What is the end result you are expecting...

It should be four million seven hundred "and" twenty two thousand five hundred and ninety five point two one. But Ricks function did not get me the and in quotes. I have not tried yours yet though. I am out somewhere will copy your and test it.

Thanks
Kelly

 

[Rick Rothstein]

It should be four million seven hundred "and" twenty two thousand five hundred and ninety five point two one. But Ricks function did not get me the and in quotes. I have not tried yours yet though. I am out somewhere will copy your and test it.

How does the following comment (highlighted in red below) which you posted in Message #5 figure in then? What did you mean about the currency text?

Hello Rick,
Thanks for such a great function. I love it!!!

Now my issue is how do I get my local currency instead of the dollar?

 

[kelly mort]

How does the following comment (highlighted in red below) which you posted in Message #5 figure in then? What did you mean about the currency text?

I mean I wanna get say Cedis display when I used the "Dollar" with the function. I tried to modify it but no success.

Thanks

 

[kelly mort]

I have mentioned the below function on different thread, you can use the formule.
Also for if you can replace the DOLLAR and CENTS as per your currency.

Hello Mark,

After spending some time with this formula, I am loving it gradually. Now I wish I can get raw value instead of saying Dollars and cents. That is say One hundred and ninety five point two six (195.26)
Thanks
Kelly

 

[MARK858]

Kelly, below is the last time that I am changing the formula as it does my eyes in (although I have probably missed something)

Excel Workbook
	B	C	D	E
1	196326893564.09			One Hundred And Ninety-Six Billion Three Hundred And Twenty-Six Million Eight Hundred And Ninety-Three Thousand Five Hundred And Sixty-Four Point Nine
Sheet2

 

[MARK858]

Said I would have missed something... corrected below...

Excel Workbook
	B	C	D	E
1	196326893564.01			One Hundred And Ninety-Six Billion Three Hundred And Twenty-Six Million Eight Hundred And Ninety-Three Thousand Five Hundred And Sixty-Four Point One
Sheet2