Lucien asked,
" Is that a relic from prehistoric ages ?"
Yes.
E was the original exponent marker for what we would now call float values.
D was added to distinguish double from (single-precision) float.
This had nothing to do with (Visual) Basic (for Applications) originally.
To know what is
Sorry, it is
+#,##0.00;-#,##0.00;0.00
(stray ";" below)
-Original Message-
From: dennis.hamil...@acm.org
Sent: Saturday, June 18, 2022 10:37
To: '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
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.