OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Accounting format in Open Office

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Thomas L.
Newbie
Newbie


Joined: 22 Oct 2003
Posts: 1

PostPosted: Wed Oct 22, 2003 12:23 pm    Post subject: Accounting format in Open Office Reply with quote

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
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Thu Oct 23, 2003 8:29 am    Post subject: Reply with quote

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
View user's profile Send private message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Thu Oct 23, 2003 9:48 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
braan_h
Guest





PostPosted: Sat Apr 10, 2004 5:07 am    Post subject: right on track formating problems Reply with quote

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
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Sat Apr 10, 2004 7:12 am    Post subject: Reply with quote

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
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Sat Apr 10, 2004 7:16 am    Post subject: Reply with quote

dont know about empty leading spaces though!
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group