Log in to start a topic

Format is not displaying 0s

Posted by: johngiblin on 6 January 2021, 1:04 am EST

  • johngiblin

    • Post Options:
    • Link
      Copy

    Posted 6 January 2021, 1:04 am EST

    When a cell value is 0 it is apearing as blank.

    My current format is below

    let formatString = '#,##0;(#,###0';

    I changed it to the following with no luck

    let formatString = '#,###;(#,###)';

  • johngiblin

    Posted 6 January 2021, 4:35 am EST

    sorry this works as expected

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

  • © 2023 MESCIUS inc. All Rights Reserved.  ·  1.800.858.2739

    All product and company names herein may be trademarks of their respective owners.