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
Marcus
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
Marcus
1 Answer, 1 is accepted
0
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; ;@".
Regards,
Tanya
Telerik
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; ;@".
Regards,
Tanya
Telerik
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.