Converting a number to written text

DerekJeterGirly · Mar 12th, 2002, 08:46 AM

Is it possible to have a cell's sum convert to write out the sum in long verion?
Example cell D3's sum is $100.00 and I reference cell F20 to equal sum of cell D3 but display it as One Hundred Dollars and 00/100. This may be hoping for too much, but it would make my task a lot easier.

Barrie Davidson · Mar 12th, 2002, 08:51 AM

Quote:

On 2002-03-12 07:46, DerekJeterGirly wrote:
Is it possible to have a cell's sum convert to write out the sum in long verion?
Example cell D3's sum is $100.00 and I reference cell F20 to equal sum of cell D3 but display it as One Hundred Dollars and 00/100. This may be hoping for too much, but it would make my task a lot easier.

Have a look at:

http://www.barasch.com/excel/numb2words.htm

Regards,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:46 AM	#1
DerekJeterGirly New Member Join Date: Mar 2002 Posts: 1	Is it possible to have a cell's sum convert to write out the sum in long verion? Example cell D3's sum is $100.00 and I reference cell F20 to equal sum of cell D3 but display it as One Hundred Dollars and 00/100. This may be hoping for too much, but it would make my task a lot easier.