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]
