Need Help in formatting Cells

[yrajnani]

Hi,

Attached is an example of issue that I am facing
All figures that are in brackets should appear with a minus sign and in $

$(1,125,000) should appear as
$ -1,125,000.. without changing the position of dollar sign..Atttached is a sample sheet

Can anyone please help in this?
A prompt response would be highly appreciated.

Thanks,
Yogita


$(3,402,000) As it is
$-3362000 Paranthesis removed, however missing 1000 seperator
$ -9,104,000 Paranthesis removed, minus sign added, however $ symbol is displaced

 

[Gerald Higgins]

Try custom format...

$#,##0;$-#,##0