Cell format for suppressing the number 0 in cells?

2 posts, 0 answers
  1. Marcus
    Marcus avatar
    35 posts
    Member since:
    Aug 2012

    Posted 02 Dec 2014 Link to this post

    Dear support,

    in Excel the cell format "#.##0,00;-#.##0,00;;@" suppresses values equal zero i.e. no value is displayed in the cell.

    This format-string does not work in your spread sheet. Is there another format string to achieve this.

    Thanks in advance


  2. Tanya
    Tanya avatar
    577 posts

    Posted 05 Dec 2014 Link to this post

    Hi Marcus,

    Thank you for reporting this issue. I logged it into our backlog. Your Telerik points were updated for the report and you can track our progress on this at Formatting string #.##0,00;-#.##0,00;;@ does not work in spreadsheet.

    Meanwhile, there is a workaround - you just have to type one space between the two semicolons: "#.##0,00;-#.##0,00; ;@".


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top