# What is the format for negative numbers surrounded by() instead of a minue sign? [closed]

What is the format for currency negative numbers to be represented with a ( ) instead of a - sign in red? Have tried to modify current formats and the closest I can get is $(1,1234.00). Thank you !!! cpnewuser edit retag reopen merge delete ### Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2015-11-07 10:57:41.822435 ## 2 Answers Sort by » oldest newest most voted And what format do you want achieve? edited. Maybe this: ($ #,##0.00);[RED]($#,##0.00)  more ## Comments Thank You!!! This works great!! Appreciate your help!! ( 2013-08-28 17:34:17 +0100 )edit The value of the cell with negative numbers should be expressed as ($123.45) in red. Under the category "Numbers" there is a format for negative numbers (123.56) in red. Just need to add the \$ sign after the first (.

Thanks!!! cpnewuser

more