I'm unable to figure out how to get a dash to display instead of 0 with MISSING in Excel. I tried SET NODATA = - and it still doesnt work. Any suggestions? I've searched the forum but find stuff on empty cells and 0's. I might be searching wrong though.

Thanks

This message has been edited. Last edited by: JOE,

Is the value really null or 0?

It seems the NODATA character for null data is ignored for EXL2K, but works for EXL07:

SET NODATA=-
TABLE FILE CAR
SUM
SALES
BY COUNTRY
ACROSS SEATS
ON TABLE PCHOLD FORMAT EXL07
END

Thanks Francis. Is there an issue using EXL07 off a SQLOUT? The car sample worked fine.

Thanks,

There is no issue using EXL07 off a SQL Passthru request. However, some WebFOCUS styling doesn't work the same way in EXL07. You'd have to give it a try with your stylesheet. I would run it in the two formats (EXL07 and EXL2K) and verify that the differences in the output style are acceptable. Somewhere on the IBI Tech Support site is a document describing the differences.