SaBrienNew Contributor II12 months agoSolvedCube View NoData Formatting in Excel Is there a way to format 'NoData' cells so that when the report exports to excel it shows a dash or 0, instead of the cell being blank?
KrishnaValued Contributor12 months agoSaBrien - Try this setting in the CV Cell Format in Excelformat ExcelNumberFormat = [#,###,0;(#,###,0);-]
SaBrienNew Contributor II to Krishna12 months agoWe've tried many variations using the excel number format but none seem to work. Any cell that has 'NoData' will be blank and we were wanting them to show zeros.
SaBrienNew Contributor II to Krishna12 months agoWe've tried many variations using the excel number format but none seem to work. Any cell that has 'NoData' will be blank and we were wanting them to show zeros.
Related ContentCube View Excel Cell FormattingHeader format in ExcelConfirmation Rule to check for nodata vs 0Sample Excel FormulasShow Report formatting
