Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 3 of 3
  1. 03-11-2010 12:03 AM #1
    atvrider Guest

    Default How to convert a ($200) cell to a written amount(Two hundred doll

    Is there way to convert dollar amount in a cell to a written amount like
    $250.00 to two hundred and fifty dollars and 00/00 cents.
    Reply With Quote Reply With Quote  
  2. 03-11-2010 05:24 AM #2
    L. Howard Kittle Guest

    Default Re: How to convert a ($200) cell to a written amount(Two hundred doll

    Perhaps here...

    http://support.microsoft.com/kb/213360/en-us

    HTH
    Regards,
    Howard

    "atvrider" <atvrider@discussions.microsoft.com> wrote in message
    news:58BAE8B4-5A53-4A27-B585-E664551A6C97@microsoft.com...
    > Is there way to convert dollar amount in a cell to a written amount like
    > $250.00 to two hundred and fifty dollars and 00/00 cents.


    Reply With Quote Reply With Quote  
  3. 03-11-2010 11:02 AM #3
    Bob Phillips Guest

    Default Re: How to convert a ($200) cell to a written amount(Two hundred doll

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

    --

    HTH

    Bob

    "atvrider" <atvrider@discussions.microsoft.com> wrote in message
    news:58BAE8B4-5A53-4A27-B585-E664551A6C97@microsoft.com...
    > Is there way to convert dollar amount in a cell to a written amount like
    > $250.00 to two hundred and fifty dollars and 00/00 cents.


    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

Similar Threads

  1. change a Figures into text in my excel exp. 200->two hundred
    By Kems in forum Worksheet Functions
    Replies: 2
    Last Post: 02-22-2009, 12:17 AM
  2. Convert amount in cell to words
    By Raj Shah in forum General Excel Discussion
    Replies: 4
    Last Post: 01-13-2009, 02:07 AM
  3. HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED
    By VISHU in forum Worksheet Functions
    Replies: 2
    Last Post: 01-08-2009, 12:45 AM
  4. convert 500.00 to Five Hundred
    By John 22 in forum Worksheet Functions
    Replies: 2
    Last Post: 01-06-2009, 07:14 PM
  5. How do I convert $500 to Five Hundred Dollars?
    By tab2976 in forum Worksheet Functions
    Replies: 2
    Last Post: 01-06-2009, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules