Maybe a duplicate: Issue 15773 deals with providing an "accounting" format for
values, but I can't tell if this is asking for the same format.

The other issue does not relate to standard accountancy practice. It relates to 
currency symbols and a button not working properly. There is a difference 
between 'accounting' and professional accountancy practice used by various 
professionals. Currency numbers are not accountancy numbers. The currency 
symbol is typed a column or row and the number formatting of the data is as 
above without currency symbols and negative numbers in brackets and 0s as -. 
For those who don't know how to create their own formatting, the software would 
be unusable.

Another point is single and double underline. For accountancy purposes the 
underlines have to cover the whole cell not just the text within the cell. 
Formatting borders function is not appropriate to use for this purpose as these 
symbols are typed on a regular basis. There should be a drop down box with 
standard accountancy underline combinations - single top and double bottom, 
single top and single bottom, single top, single bottom, double bottom, thick 
bottom. Excel recognises that this is vital ( but they don't recognise 
accountancy number format) The borders function is used for special formatting 
only not to create standard underline formats.

 Accountants and bookkeepers are frustrated with this. It appears to them that 
spreadsheet software has alot of fancy functions but doesn't pay attention to a 
few of the key fundamentals underpinning what they are about.

Requests here are most likely to get attention if they
a) focus on a single, specific topic, and
b) spell out as clearly as possible exactly what is needed.

I believe the underlining you mentioned is covered by Issue 23839.

> Minus signs in brackets (5,000.00)and zero should display as a dash -.

This is possible with Calc's current number formats, using a custom number
format, something like this: #,##0.--;(#,##0.--);--

  |     Value |   Formatted |
  |-----------+-------------|
  |  12345.67 |   12,345.67 |
  | -12346.67 | (12,346.67) |
  |     12345 |   12,345.-- |
  |         0 |          -- |

If that's not what you're after, please give some clear examples showing the
values and the formatted display.

I think the requests for a "accountancy number format" should be collected in
one issue. Therefore I set this as duplicate to issue 15756. (The underline is
covert by issue 23839.)

*** This issue has been marked as a duplicate of 15756 ***

closing, duplicate