How do you get Numbers to put negative amounts in brackets?

I am using a Numbers spreadsheet. Negative numbers are formatted as -1234. How do I format them as (1,234.00)?

Posted on Oct 3, 2019 8:10 AM

Similar questions

Formatting negative values in Apple Numbers How do I have negative numbers display in parentheses or brackets?
1924 1
Numbers negative values This question might need a Numbers Whizz to answer. I have a large spreadsheet and in some columns where the calculation is a negative number in sterling I get what I want to see which is a minus followed by the pound sterling sign and then the value. Clearly any positive calculation is in black text so it is easy to see at a glance what is positive and what is a negative value. What I do not understand is that I also have calculations in the same sheet where the negative sterling value is all in black so it is a black minus sign black pound sterling sign and black value. If I go to the Cell tab and select Currency I am given the option, alongside the number of decimals I want, of two choices for negative numbers which are red. One is just the value in red and the other is the value in brackets in red. Can someone tell me why I am not given the option of a minus sign followed by the currency symbol and the value all in red so that all negative numbers in the sheet are consistent in style ? Thanks.
3659 4
Using Numbers I’m using a Numbers budget template. However the formulas aren’t consistent throughout the spreadsheet. For instance, a negative difference in one row reads as -$4. In other rows it reads as ($4). How do you change the formula for this? I can’t seem to find the way to correct this issue.
245 1

3 replies

t quinn

Level 5

7,063 points

Oct 3, 2019 8:16 AM in response to DavidO198

Hi David,

Use Accounting Style:

or my fav

quinn

t quinn

Level 5

7,063 points

Oct 3, 2019 8:28 AM in response to DavidO198

Hi David,

Yes! Same choices with the numbers format.

quinn

DavidO198 Author

Level 1

15 points

Oct 3, 2019 8:25 AM in response to t quinn

Obvs!!! That works well - thanks. Is there a way of doing it without the currency symbol?

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do you get Numbers to put negative amounts in brackets?