Is there a formula on changing numerical dollar amt to their written-out
form? If there is, can you tell me?

Hi,

There are several versions of this available, I like this one

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"Shihachi" wrote:

Is there a formula on changing numerical dollar amt to their written-out
form? If there is, can you tell me?

There is:
http://support.microsoft.com/default.aspx/kb/213360
Micky


"Shihachi" wrote:

Is there a formula on changing numerical dollar amt to their written-out
form? If there is, can you tell me?

Numbers to words
http://www.sulprobil.com/html/spellnumber.html
1E+15 Error (Absolute amount 999999999999999)! <<<<<
0,123 Zero Dollars and Twelve Cents (rounded)
-1 Minus One Dollar and Zero Cents
20,123 Twenty Dollars and Twelve Cents (rounded)
-20,123 Minus Twenty Dollars and Twelve Cents (rounded)
1,01 One Dollar and One Cent
1000001,01 One Million One Dollars and One Cent

http://www.contextures.com/excelfilesRon.html (VBA)
1E+15 #ZAHL!
0,123 No Dollars and No Cents
-1 #WERT!
20,123 Twenty Dollars and No Cents
-20,123 #WERT!
1,01 One Dollar and No Cents
1000001,01 One Million One Dollars and No Cents

http://support.microsoft.com/default...b;en-us;213360
1E+15 Hundred Fifteen Dollars and No Cents
0,123 No Dollars and Twelve Cents
-1 One Dollar and No Cents
20,123 Twenty Dollars and Twelve Cents
-20,123 Hundred Twenty Dollars and Twelve Cents
1,01 One Dollar and One Cent
1000001,01 One Million One Dollars and One Cent

http://www.ozgrid.com/VBA/ValueToWords.htm
1E+15 Hundred Fifteen Dollars and No Cents
0,123 No Dollars and Twelve Cents
-1 One Dollar and No Cents
20,123 Twenty Dollars and Twelve Cents
-20,123 Hundred Twenty Dollars and Twelve Cents
1,01 One Dollar and One Cent
1000001,01 One Million One Dollars and One Cent

Please note that in German Excel the "," represents the "." but you
should get similar results.
IMHO any serious spellnumber function should check its inputs
thoroughly and all your suggested versions DON'T (to be fair to
XLDynamics, I did not check recently, so that's maybe an outdated
status of information).

The above is from Bernd Plumhoff who sent this message long ago

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Shihachi" wrote in message
...
Is there a formula on changing numerical dollar amt to their written-out
form? If there is, can you tell me?

Numbers to words:
a.. http://support.microsoft.com/kb/213360
b.. http://www.xldynamic.com/source/xld.xlFAQ0004.html
c.. http://www.ozgrid.com/VBA/ValueToWords.htm

--
David Biddulph

"Shihachi" wrote in message
...
Is there a formula on changing numerical dollar amt to their written-out
form? If there is, can you tell me?