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