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)?
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I am using a Numbers spreadsheet. Negative numbers are formatted as -1234. How do I format them as (1,234.00)?
Hi David,
Yes! Same choices with the numbers format.
quinn
Hi David,
Yes! Same choices with the numbers format.
quinn
Hi David,
Use Accounting Style:
or my fav
quinn
Obvs!!! That works well - thanks. Is there a way of doing it without the currency symbol?
How do you get Numbers to put negative amounts in brackets?