Need Excel function to convert dollars to written words
Does anyone know how to convert a numeric dollar amount into written dollar
amount using Excel? Example cell contains 25.35 and I want a function to express it as TWENTY FIVE DOLLAR AND 35 CENTS. |
Need Excel function to convert dollars to written words
http://www.ozgrid.com/VBA/CurrencyToWords.htm
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "JoAnne" escreveu: Does anyone know how to convert a numeric dollar amount into written dollar amount using Excel? Example cell contains 25.35 and I want a function to express it as TWENTY FIVE DOLLAR AND 35 CENTS. |
Need Excel function to convert dollars to written words
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "JoAnne" wrote in message ... Does anyone know how to convert a numeric dollar amount into written dollar amount using Excel? Example cell contains 25.35 and I want a function to express it as TWENTY FIVE DOLLAR AND 35 CENTS. |
All times are GMT +1. The time now is 12:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com