Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

DavidO198 Author

Level 1

15 points

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

Reply

Best reply

Level 5

7,043 points

Posted on Oct 3, 2019 8:28 AM

Hi David,

Yes! Same choices with the numbers format.

quinn

View in context

Similar questions

Formatting negative values in Apple Numbers How do I have negative numbers display in parentheses or brackets?
1111 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.
2508 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.
105 1

3 replies

Best reply

Level 5

7,043 points

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

Hi David,

Yes! Same choices with the numbers format.

quinn

Reply

Level 5

7,043 points

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

Hi David,

Use Accounting Style:

or my fav

quinn

Reply

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?

Reply

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

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up