Forum Discussion

DonnaJOC's avatar
DonnaJOC
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;;@")))

 

 

Resources