| View previous topic :: View next topic |
| Author |
Message |
Thomas L.
Newbie
Joined: 22 Oct 2003
Posts: 1
|
 Posted: Wed Oct 22, 2003 12:23 pm Post subject: Accounting format in Open Office |
 |
|
| I am trying to get dollar signs to line up at the left edge of a cell. In Excel I just need to use the accounting format. Does anyone know the user defined format code to put in so this will work? I have tried the Excel one but it doesn't work. |
|
| Back to top |
|
 |
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Thu Oct 23, 2003 8:29 am Post subject: |
|
|
format>numbers>currency> and choose which currency sign you want.
The default is set in tools>options<spreadsheet>language settings
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
maxqnz
Super User
Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa
|
| Posted: Thu Oct 23, 2003 9:48 am Post subject: |
|
|
| carl wrote: | format>numbers>currency> and choose which currency sign you want.
The default is set in tools>options<spreadsheet>language settings |
But where is the option to left alighn the currency symbol, so that, instead of:
[space][space][space]$123.45
one has:
$[space][space][space]123.45
as in this screenshot of Quattro Pro:
I can't find that option in OpenOffice Calc either.
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?
OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3 |
|
| Back to top |
|
|
braan_h
Guest
|
| Posted: Sat Apr 10, 2004 5:07 am Post subject: right on track formating problems |
|
|
I am in complete agreement with you. The $ is not aligned correctly and the negative numbers are not represented with (). Please do not give up, I found this to be a key issue also.
thx
b |
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Sat Apr 10, 2004 7:12 am Post subject: |
|
|
when you go into Format cell>currency
you can create and add what you want in the panel below
You do need to know the rules but by fooling around with diffrent tryout youll soon get most of what you could want.
[$widgets-407]#.##0,00 ;[yellow][$widgets-407](#.##0,00)
gives you a user defined
positve value widgets1,00
negative value widgets(2,00) in yellow
Have fun!
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Sat Apr 10, 2004 7:16 am Post subject: |
|
|
dont know about empty leading spaces though!
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
|
