Ask Your Question

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

asked 2013-08-26 23:48:41 +0100

CPNewUser gravatar image

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 flag offensive 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

answered 2013-08-27 00:49:15 +0100

m.a.riosv gravatar image

updated 2013-08-28 00:50:10 +0100

And what format do you want achieve?


Maybe this:

($ #,##0.00);[RED]($ #,##0.00)
edit flag offensive delete link more


Thank You!!! This works great!! Appreciate your help!!

CPNewUser gravatar imageCPNewUser ( 2013-08-28 17:34:17 +0100 )edit

answered 2013-08-27 22:43:33 +0100

CPNewUser gravatar image

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

edit flag offensive delete link more


Thank you!! This format works great!!! Apprecitate your help!!!!

CPNewUser gravatar imageCPNewUser ( 2013-08-28 17:33:15 +0100 )edit

Question Tools

1 follower


Asked: 2013-08-26 23:48:41 +0100

Seen: 779 times

Last updated: Aug 28 '13