Discussion Locked

Accounting cell format in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My negative values in excel cells are not putting brackets when I try to apply the accounting function. I assumethe accounting function is not working. How do I turn it on?

2 replies

by chitosunday

How did you format it? click format ,cells ,numbers,accounting. See the sample shown on top right of the dialog box if it shows a bracket.

by hardhead

Accounting format does not allow for negative numbers. If you want the option to display negative numbers you need to use currency format instead.

This discussion is closed to new replies.