| View previous topic :: View next topic |
| Author |
Message |
PTR7
Newbie
Joined: 18 Mar 2012
Posts: 3
|
 Posted: Sun Mar 18, 2012 7:18 am Post subject: cell formatted Currency displays Percentage when negative |
 |
|
| 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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Mar 18, 2012 7:24 am Post subject: |
|
|
| Quote: | | Anyone else run into this problem? |
No, you are the only one.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
PTR7
Newbie
Joined: 18 Mar 2012
Posts: 3
|
| Posted: Sun Mar 18, 2012 7:33 am Post subject: |
|
|
| 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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Mar 18, 2012 8:19 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
|
