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
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
And what format do you want achieve?
edited.
Maybe this:
($ #,##0.00);[RED]($ #,##0.00)
Thank You!!! This works great!! Appreciate your help!!
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
Thank you!! This format works great!!! Apprecitate your help!!!