=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