LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default Format a dollar amount to text

Is there a way to take $10.56 and format it to read Ten dollars and 56 cents.

Thanks in advance for your help.

Jordan
 
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
Yes or No Value if Dollar amount between two numbers Jerry B Smith Excel Worksheet Functions 1 February 2nd 09 04:55 PM
Comparing Row by Row - A-D dollar amounts to E dollar amount Mel Excel Worksheet Functions 9 November 20th 08 09:50 PM
How to use a name to represent a dollar amount Item Manager Excel Discussion (Misc queries) 1 May 6th 08 08:20 PM
multiply a text box on a report times a dollar amount gbpg Excel Discussion (Misc queries) 2 December 9th 07 09:33 AM
Hide row if dollar amount is zero Karl Irvin Excel Discussion (Misc queries) 5 May 7th 05 12:08 AM


All times are GMT +1. The time now is 04:52 AM.

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

About Us

"It's about Microsoft Excel"