| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can any one tell me how to convert figures into words automatical. | Excel Worksheet Functions | |||
| do u know about Excel tool that would convert figures into words | Excel Discussion (Misc queries) | |||
| Is there something like Word's "CREATEDATE" function in Excel? | Excel Discussion (Misc queries) | |||
| can excel convert number into words (like 10 to ten)? | Excel Worksheet Functions | |||
| WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003??? | Excel Worksheet Functions | |||
Linear Mode
