A developer has a text field in a data extension they want to format using...

The FormatCurrency AMPscript function is used to format a numeric value as a currency. To return a value of $6.96, the function would correctly format inputs like:

6.96 (B) - This is a direct numeric value that will be formatted to $6.96.

6.96 (D) - Same as above, the numeric value is directly formatted to $6.96.

Using FormatCurrency(6.96) in AMPscript will result in $6.96.