PC Review


Reply
Thread Tools Rate Thread

Amount to text

 
 
JCLSB
Guest
Posts: n/a
 
      16th Sep 2006
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


 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      16th Sep 2006
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:24 AM.