Remember Me?

#1
November 9th 06, 05:48 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 53
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
November 9th 06, 05:51 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,047
Need Excel function to convert dollars to written words

http://www.ozgrid.com/VBA/CurrencyToWords.htm

hth
--
regards from Brazil
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
November 9th 06, 05:52 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 10,594
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post viral_pandya_virurids Excel Worksheet Functions 1 August 3rd 06 06:40 PM Jagesh Excel Discussion (Misc queries) 3 December 3rd 05 10:31 PM - ML - Excel Discussion (Misc queries) 5 July 25th 05 09:26 PM nivedrajesh Excel Worksheet Functions 2 July 11th 05 01:06 PM dan Excel Worksheet Functions 2 May 5th 05 06:03 AM

All times are GMT +1. The time now is 05:48 AM.