Sorry, it is
+#,##0.00;-#,##0.00;0.00
(stray ";" below)
-----Original Message-----
From: dennis.hamil...@acm.org <dennis.hamil...@acm.org>
Sent: Saturday, June 18, 2022 10:37
To: 'qa@openoffice.apache.org' <qa@openoffice.apache.org>
Subject: RE: Value returned by CInt("+1")
Excel has it so there has to be a solution in AOO Calc. And indeed there is.
It is in the built-in Help under Number Format Codes. Here is a conventional
sign everything and show 0's format code for currency values (without any $)
that I use in some investment tracking.
+#,##0.00;-#,##0.00;; 0.00
-----Original Message-----
From: Carl Marcum <cmar...@apache.org>
Sent: Saturday, June 18, 2022 08:49
To: qa@openoffice.apache.org
Subject: Re: Value returned by CInt("+1")
[orcmid] [ ... ]
If I enter +1 into a cell my default number format changes it to a 1.
I haven't found any number format options where positive values have a leading
+ but I haven't checked them all.
[orcmid] [ ... ]
---------------------------------------------------------------------
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
