This is a migrated thread and some comments may be shown as answers.

Cell format for suppressing the number 0 in cells?

1 Answer 31 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marcus
Top achievements
Rank 1
Marcus asked on 02 Dec 2014, 03:13 PM
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

1 Answer, 1 is accepted

Sort by
0
Tanya
Telerik team
answered on 05 Dec 2014, 11:53 AM
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
 

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.

 
Tags
Spreadsheet
Asked by
Marcus
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Share this question
or