topic Strange num() Format Code behavior in Archived Groups

Strange num() Format Code behavior

pennetzdorfer — Wed, 23 Jul 2025 14:48:52 GMT

Hello,

I've noticed a strange issue when using format codes in num() function:

num(SomeValue, '+#.##0; -#.##0; +/-0') doesn't work as supposed.

Please see the following discussion:

Regards,

Florian

rbecher — Tue, 12 Aug 2014 20:35:43 GMT

Hi Florian,

as a workaround you could use ASCII plus-minus sign:

0xB1 or

chr(177)

=num(SomeValue, '+#.##0;-#.##0;±0')

..or a Unicode combination (my suggestion):

U+207a (superscript plus sign) U+2044 (fraction slash) U+208b (subscript minus) or

chr(8314) & chr(8260) & chr(8331)

=num(SomeValue, '+#.##0;-#.##0;⁺⁄₋0')

Btw. I would omit the spaces in the format string.

- Ralf

pennetzdorfer — Wed, 13 Aug 2014 07:12:51 GMT

Great workaround ... thank a lot, Ralf!

Regards,

Florian