Thanks Paul- Your suggestion for accounting was very close to what I need, although in Excel 2003 (which is what I have), the column is not blank, it leaves a dash for some reason.
However, as a result of your suggestion, I noticed the Custom format option, and found that I could do it by using # sign for each place. I'll have to see if there's a way to make this format permanent, so they don't have to re-do this every time they run the vfp report to get the data. Anyway, thanks for your suggestion, very helpufl. -Steve At 04:13 PM 09/17/2009, you wrote: >On Thu, Sep 17, 2009 at 8: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... > >One of the numeric formats does this. 'accounting' I think? I only >have OpenOffice here... > >-- >Paul > > [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.
