Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dspratley
 
Posts: n/a
Default Function to Convert dollar to text?

I am looking for a function to convert a dollar amount (number) to text. For
example, $10.50 would display as "Ten Dollars".
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Function to Convert dollar to text?

Hi,

This link might help

http://support.microsoft.com/?kbid=213360

Regards,
Bondi

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Function to Convert dollar to text?

http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"dspratley" wrote in message
...
I am looking for a function to convert a dollar amount (number) to text.

For
example, $10.50 would display as "Ten Dollars".



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Is there a macro or function to convert values to it written text Dang Tran Excel Worksheet Functions 1 April 19th 06 11:17 PM
Improve Excel Help Text - Make easier to Find Function Refs RichardAllen Excel Worksheet Functions 0 April 10th 06 05:52 AM
How to Convert Figures into Text in Excel m_azim1 Excel Worksheet Functions 3 April 5th 06 05:45 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"