LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Total in Money Converted into Letters!!!

Hi All,
My Excel program has a TOTAL at the end of all the Items
sold. But on the bottom of that, I have to fill in everytime
in letters of what the TOTAL gives me. Is there any way
to make that happen by itself?

Exp. TOTAL is $900.00
On the other line, I have to fill in:
Nine Hundred Dollars and 00/100
and I do a lot of this and sometimes
I dont write the exact amount, so I
want to know if anybody knows of a
better way to do this. Thank You.
--
Computer Tech
 
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
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Pivots - Auto calc % Sub total is of grand total VBA Noob Excel Discussion (Misc queries) 3 August 8th 06 08:46 PM
Pivot Table Sub total and totals Karen53 Excel Worksheet Functions 4 July 23rd 06 07:04 PM
sum of total hours not correct Bruno Lauwers Setting up and Configuration of Excel 9 September 6th 05 08:03 AM
show in a excel graphic a total percentage for 5 diff data fiels Julio Charts and Charting in Excel 1 September 1st 05 01:26 PM


All times are GMT +1. The time now is 09: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"