Sorry, it is +#,##0.00;-#,##0.00;0.00
(stray ";" below) -----Original Message----- From: [email protected] <[email protected]> Sent: Saturday, June 18, 2022 10:37 To: '[email protected]' <[email protected]> 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 <[email protected]> Sent: Saturday, June 18, 2022 08:49 To: [email protected] 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
