Formatting numbers with leading " - "

[exflyer1996]

Hi,

I am trying to take a value and format it as a number with a leading " - " an no thousands separators. EXAMPLE: (50,000.00) should be formatted as -50000.00

Any suggestions?

 

[Aaron Blood]

If those are already values in cells... you should just be able to select the range and press: Shift+Ctrl+~ (to apply general number format)
...then click increase/decrease decimal button as needed.

 

[Scott Huish]

Unless you are trying to show positive numbers with a leading hyphen as well, just format as Number, 2 decimal places. Leave thousands separator unchecked