Format is not displaying 0s

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

  • 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 = '#,###;(#,###)';
  • Marked as Answer

    Replied 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