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

cell formatted Currency displays Percentage when negative

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


Joined: 18 Mar 2012
Posts: 3

PostPosted: Sun Mar 18, 2012 7:18 am    Post subject: cell formatted Currency displays Percentage when negative Reply with quote

I have an IF statement that calculates currency values. But if the result is negative, the cell displays as a Percentage, even though the formatting of the cell is Currency and all calcualted values are currency. Anyone else run into this problem?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Mar 18, 2012 7:24 am    Post subject: Reply with quote

Quote:
Anyone else run into this problem?

No, you are the only one.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
PTR7
Newbie
Newbie


Joined: 18 Mar 2012
Posts: 3

PostPosted: Sun Mar 18, 2012 7:33 am    Post subject: Reply with quote

I apologize. I should have asked, "Can anyone offer a solution to this issue?" Your reply is a little sad, really. But I like the Germans. Everytime I have been there, they have been especially nice and gracious.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Mar 18, 2012 8:19 am    Post subject: Reply with quote

In this case the only possible answer beyond wild guessing would have been: "Nobody can offer a solution without knowing a single technical detail".
Which office version? I don't dare asking for the operating system.
Which format code in which number format locale context?
Which formula?
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
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