[Solved] Accounting Format

[Mike.W-GB]

I'm new to cal having used Excell at work for many years (now retired)
Is it possible to format a cell using an accounting format rather than a currency format

[robleyd]

Many of us here are not familiar with Excel's features - I had to search to find information. By "accounting format" do you mean locking the currency symbol to the left of the cell? If not, can you explain exactly what you want to achieve?

[DiGro]

Accounting format in Excel:

https://www.excel-easy.com/examples/cur ... nting.html

[Zizi64]

https://ask.libreoffice.org/en/question ... t-in-calc/

[Mike.W-GB]

Accounting format: Currency sign lined up on left and currency to 2 decimal place aligned on the right

[Zizi64]

Accounting format: Currency sign lined up on left and currency to 2 decimal place aligned on the right

Not in Hungary.
The unit (currency sign) must be located AFTER the numeric value.
Maybe it is a locale-depending format.

[Villeroy]

The clou with accounting format is that all decimal points (or commas respectively) are lined up just like decimal tabs in Writer paragraphs. This is desparately missing in Calc.

[Sliderule]

To the best of my knowledge, Accounting Format is NOT available with OpenOffice Calc .

However, it is available with LibreOffice Calc .

According to the LibreOffice Calc Help ( F1 ) file:

Spaces

To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, _M creates a wider space than _i.

To fill free space with a given character, use an asterisk (*) followed by this character.
For instance:
*\0

will display integer value (0) preceded by as many as needed backslash characters (\) to fill column width. For accounting representation, you may left align currency symbol with a format similar to:

$_-* 0.--;$-* 0.--;$_-* -

Therefore, if it were me, I would create a Calc Template, and, define a Style, perhaps named Accounting Format, and, define the number format as above, and, probably change the currency symbol ( $ ) as you desire.

For example without or with thousands separator:

• £_-* 0.--;£-* 0.--;£_-* -
• £_-* ###,##0.--;£-* ###,##0.--;£_-* -

Attached below is a sample file that provides Accounting Format as you described it and it works with LibreOffice Calc .

Acct_Format.ods

(17.39 KiB) Downloaded 289 times

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.