Forum Discussion

Copper Contributor

Aug 23, 2023

Solved

Concatenate not pulling negative dollar value

Hello, This is the formula I used. How do I get the negative values to show? =CONCATENATE(C2,"|",(TEXT(D2,"M/DD/YYYY")),"|",(TEXT(E2,"$##.00;;@")))

Detlef_Lewin
Aug 23, 2023
DonnaJOC
Amend the TEXT() function.
TEXT(E2,"$##.00;$-##.00;@")

Silver Contributor

Aug 23, 2023

Amend the TEXT() function.

TEXT(E2,"$##.00;$-##.00;@")