Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cyn Koubeck
  Where is Cyn Koubeck?
 
 Ohio - United States
 Cyn Koubeck
 To: Simon Arnold
  Where is Simon Arnold?
 Halifax
 United Kingdom
 Simon Arnold
 Tags
Subject: RE: Suppressing Zero fields in Excel
Thread ID: 15637 Message ID: 15952 # Views: 4 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, October 04, 2002 8:26:10 PM         
   


> > > Is there a way to suppress the zeros (through foxpro) when converting a table to a spreadsheet? Not ALL the zeros, just certain cells; if the cell shows "$0.00" can the cell be shown as " "? I know excel provides the no zero option, but it doesn't discriminate between wanted and unwanted data.
> > >
> > > Thanks in advance.
> > > Cyn
> >
> > Here's one we just got through from Help Desk. (And you think you've got problems)
> >
> > "I cannot open a file, it went dark but it is still showing that it exists? I hit my mouse down real hard and that is when it went dark. Is there a way to get it back?"
> >
> > Patrick
>
> Simply set the format to "0.00;-0.00;;@"
>
> Simon Arnold.


Simon,
Finally got around to trying this, and it works perfectly! Thanks very much for your help (and very easy code!)
Cyn

ENTIRE THREAD

suppress zeros in excel Posted by Cyn Koubeck @ 9/26/2002 5:11:14 PM
RE: suppress zeros in excel Posted by Yuri Rubinov @ 9/26/2002 7:26:12 PM
RE: suppress zeros in excel Posted by Cyn Koubeck @ 9/27/2002 3:05:54 PM
RE: suppress zeros in excel Posted by Yuri Rubinov @ 9/27/2002 8:01:47 PM
RE: Speaking of Excel - Animal abuse Posted by Patrick Dowd @ 9/27/2002 8:30:56 PM
Suppressing Zero fields in Excel Posted by Simon Arnold @ 9/28/2002 12:54:38 AM
RE: Suppressing Zero fields in Excel Posted by Cyn Koubeck @ 10/4/2002 8:26:10 PM
RE: Suppressing Zero fields in Excel Posted by Jill Lindgren @ 4/8/2006 11:31:00 PM
RE: Suppressing Zero fields in Excel Posted by Simon Arnold @ 4/10/2006 12:37:23 PM