On Thu, Sep 17, 2009 at 1:56 PM, Steve Ellenoff <[email protected]> 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. > How about replacing the zero values with nulls. The nulls will become empty cells in excel. You could use the EVL() function to do this while populating your cursor.
-- Dave Thayer Denver, CO _______________________________________________ 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.
