In Numbers ’09, can I change the Currency Cell Format to default to Accounting Style
formattingnumbers
Related Solutions
I found the following tutorial at Apple that has the answer to my own question: The default table styles are always taken from the table style list that you choose from the panel on the bottom-left corner of the screen.
The solution to my problem is to use the Create New Table Style command under the Format menu and adding a brand new table style. As long as this new style remains selected, it is the one that the table will keep as a whole.
I have tried this at home and it works as advertised.
If I understand your question, Numbers does this by default - note the darkened row and column identifiers in the image below at AK50.
Edit: ah, I see.. okay, I found an inconvenient hack:
- Select the Column containing your target cell
- Cmd click the cell above (or the Cmd Click the row index of the cell above)
- Cmd click the Row containing your target cell
- Cmd click to reselect the cell above your target
Like so:
Maybe you could use automator to make this less painful?
Related Question
- Numbers: How to change cell text conditionally
- Change Default Table Style when opening a CSV file
- Change date format in Numbers 3.2
- Apple Numbers: how to change a date format to a number format
- How to change the default format in Numbers
- Use variable in Numbers cell formula
- MacOS – How to format a cell with data YYYYMMDD in Numbers to be a date type
- How to empty a cell in Numbers without formatting the cell
Best Answer
Unfortunately, it does not appear so. In fact, when you check the "Accounting Style" button, you may notice that the
$symbol up in the toolbar actually gets deselected. From Numbers's perspective, accounting style is different from the standard currency style present in the toolbar.You can, if you like, define your own custom cell style that does what you want. You can see here, I've added an "Accounting" style in the drop down menu:
And my "Accounting" style is defined like this:
Really, though, I don't know that accessing things through the drop-down menu is going to be any more convenient for you than just hitting the "Accounting Style" checkbox.