Forum Discussion
DonnaJOC
Aug 23, 2023Copper Contributor
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;;@")))
2 Replies
Sort By
- Detlef_LewinSilver Contributor
- DonnaJOCCopper ContributorTHANK YOU! That worked perfectly.