[Solved] Accounting Format

Discuss the spreadsheet application

[Solved] Accounting Format

Postby Mike.W-GB » Thu Apr 23, 2020 1:16 pm

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
Last edited by MrProgrammer on Fri May 08, 2020 7:08 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice : 4.1.7
OSX: 10.15.4
Mike.W-GB
 
Posts: 2
Joined: Thu Apr 23, 2020 1:01 pm

Re: Accounting Format

Postby robleyd » Thu Apr 23, 2020 1:47 pm

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?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3458
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Accounting Format

Postby DiGro » Thu Apr 23, 2020 1:59 pm

____________
DiGro

AOO 4.1.7 on Windows 10. Scanned with ZIGGO Safe Online (F-Secure)
User avatar
DiGro
 
Posts: 103
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: Accounting Format

Postby Zizi64 » Thu Apr 23, 2020 2:45 pm

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Accounting Format

Postby Mike.W-GB » Sun Apr 26, 2020 8:30 pm

Accounting format: Currency sign lined up on left and currency to 2 decimal place aligned on the right
OpenOffice : 4.1.7
OSX: 10.15.4
Mike.W-GB
 
Posts: 2
Joined: Thu Apr 23, 2020 1:01 pm

Re: Accounting Format

Postby Zizi64 » Sun Apr 26, 2020 9:23 pm

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.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Accounting Format

Postby Villeroy » Sun Apr 26, 2020 10:32 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Accounting Format

Postby Sliderule » Sun Apr 26, 2020 11:11 pm

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:

LibreOffice Calc Help - format codes;numbers wrote:
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 19 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.
User avatar
Sliderule
Volunteer
 
Posts: 1242
Joined: Thu Nov 29, 2007 9:46 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests