Format Dollar Value to written Value

[Roco]

Trying to enter a formula to change $500.75 cents to "Five Hundred Dollars and Seventy Five Cents". I have tried <=wordnum(A1)>, but it returns it as "Five Hundred Dollars period Seventy Five" I'm not happy with that return. Any help here would be great. Thanks

[sandy666]

try: How to convert a numeric value into English words in Excel

[jeffreybrown]

Try...

A1 =$500.75
B1 =ConvertCurrencyToEnglish(A1)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[MarvinP]

Here are a few links to do this problem also:

https://support.microsoft.com/en-us/...words-in-excel
https://support.office.com/en-us/art...8-69442cd55d98
https://www.ablebits.com/office-addi...s-words-excel/

[Roco]

Thanks for your link on this....works great

[sandy666]

No Dollars and No Cents sounds great with Speak Cells. Like: No Women No Cry

[Roco]

Thanks for your help...I was getting error at line item "Cents = ConvertTens(Temp)"

[sandy666]

Honestly I don't know who should say: You are welcome