Amount to text

's Computer Specifications

Hello,

Is there a formula to take a currency value in one cell and have it spell
out the amount?
If in one cell I have $28.32 is there a formula to have it put in
Twenty Eight and 32/100 like in a check?

Thank You

JCLSB

's Computer Specifications

Bob Phillips has some links to methods of changing numbers to text.

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

On Fri, 15 Sep 2006 21:26:23 -0400, "JCLSB" <(E-Mail Removed)> wrote:

>Hello,
>
> Is there a formula to take a currency value in one cell and have it spell
>out the amount?
> If in one cell I have $28.32 is there a formula to have it put in
>Twenty Eight and 32/100 like in a check?
>
>
>Thank You
>
>JCLSB
>

Gord Dibben MS Excel MVP

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Not all text wraps in a cell containing large amount of text	=?Utf-8?B?S3Jpcw==?=	Microsoft Excel Misc	3	23rd Dec 2005 04:25 PM
Large amount of text in cells - Problem text.xls (0/1)	Patrick	Microsoft Excel Misc	2	5th May 2005 04:10 PM
Can't select a small amount of text in a text box	=?Utf-8?B?TTM=?=	Microsoft Word Document Management	2	22nd Nov 2004 11:23 PM
Amount of text in text area won't allow submit	Pete Mahoney	Windows XP Internet Explorer	0	21st Oct 2003 03:51 PM
Inputing a large amount of text into a text box??	Nick DeMerchant	Microsoft Access Getting Started	1	29th Aug 2003 01:31 PM