I am facing issues with formatting the currency.
Currently the cell has this format
$ (3,402,000) - _($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_)
Need it to look like
$ -3,402,000
I tried the format $* ?,_(###,###,###,##0_);?$* ?,_("-"###,###,###,##0_) however in this currency symbol...