Formatting a number within a text formula
 

The following text formula includes a cell address for a number between the
two parts of the text. How would I format the number in currency format -
dollar sign and comma for thousands place.

Here is the formula with A1 referencing a number:

=When the value of the asset is above "&A1&", then depreciate the asset"
--
MZ

Formatting a number within a text formula
 

=When the value of the asset is above "&TEXT(A1,"$#,##0.00")&", then
depreciate the asset"
Bob Umlas
Excel MVP

"MZ" wrote in message
...
The following text formula includes a cell address for a number between
the
two parts of the text. How would I format the number in currency format -
dollar sign and comma for thousands place.

Here is the formula with A1 referencing a number:

=When the value of the asset is above "&A1&", then depreciate the asset"
--
MZ

Formatting a number within a text formula
 

="we need about " & TEXT(A1,"$#,##0.00") & " to start work"

--
Gary''s Student - gsnu201001


"MZ" wrote:

The following text formula includes a cell address for a number between the
two parts of the text. How would I format the number in currency format -
dollar sign and comma for thousands place.

Here is the formula with A1 referencing a number:

=When the value of the asset is above "&A1&", then depreciate the asset"
--
MZ