Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Re: Strange num() Format Code behavior
Regards,
Florian
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
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
Great workaround ... thank a lot, Ralf!
Regards,
Florian