PC Review


Reply
Thread Tools Rate Thread

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

 
 
atvrider
Guest
Posts: n/a
 
      11th Mar 2010
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
 
 
 
 
L. Howard Kittle
Guest
Posts: n/a
 
      11th Mar 2010
Perhaps here...

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

HTH
Regards,
Howard

"atvrider" <(E-Mail Removed)> wrote in message
news:58BAE8B4-5A53-4A27-B585-(E-Mail Removed)...
> 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
 
Bob Phillips
Guest
Posts: n/a
 
      11th Mar 2010
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

Bob

"atvrider" <(E-Mail Removed)> wrote in message
news:58BAE8B4-5A53-4A27-B585-(E-Mail Removed)...
> 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

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
convert numbers to word like 100 convert to one hundred only =?Utf-8?B?QWJkdWwgTmFzYXI=?= Microsoft Excel Crashes 1 20th Jul 2006 12:11 PM
Convert amount in cell to words Raj Shah Microsoft Excel Discussion 4 19th Apr 2006 12:06 PM
HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED =?Utf-8?B?VklTSFU=?= Microsoft Excel Worksheet Functions 1 19th Dec 2005 10:49 AM
how do i convert 100 in one cell to one hundred in another cell =?Utf-8?B?TnVtYmVycyBpbnRvIHdvcmRz?= Microsoft Excel Misc 1 22nd Oct 2005 11:35 AM
How to convert 100 to One Hundred Microsoft Access VBA Modules 1 1st Mar 2004 07:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:33 AM.