Steve Could you not (conditionally) set the forecolor to be the same as the backcolor for those cells with 0 values ?
You'd still need to post-process the XLS (as others have suggested) Paul Steve Ellenoff wrote: > I have an app that exports a bunch of data to excel using the COPY TO > XL5 command. The client recently asked if the numeric fields could be > blank when the value was zero for easy reading. I couldn't find any > easy way to do this in Excel through formatting... so I changed the > exported data to a char field to accommodate this, but now they are > not happy that they can no longer use the =SUM() on the column. > > I told them I could add a numeric version of the column near the end > for totaling, but they really don't love this solution. > > > Is there a better way to handle this? > > Thanks for all suggestions > -Steve > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
