Microsoft KB Archive/61578

{|
 * width="100%"|

DOLLAR Function Returns Text Value

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

-

Use of the DOLLAR function in Microsoft Excel returns a value that is formatted as text. When trying to use the returned value from a formula using the DOLLAR function in a worksheet formula, a value of zero is returned.

To sum the values returned by a DOLLAR function, use an addition formula, such as =A1+A2, where A1 and A2 have text values returned from a formula using the DOLLAR function.

Numeric values that exist as text, such as =&quot;25&quot;, or the text values returned by a formula, such as =DOLLAR, can be used in formulas that use standard mathematic operators (for example +,-,*, or /) but not in worksheet formulas.

Additional query words: 2.0 2.00 2.01 2.1 2.10 3.0 4.0

Keywords :

Version :

Platform :

Issue type :

Technology :