Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Simon Arnold
  Where is Simon Arnold?
 Halifax
 United Kingdom
 Simon Arnold
 To: Patrick Dowd
  Where is Patrick Dowd?
 
 California - United States
 Patrick Dowd
 Tags
Subject: Suppressing Zero fields in Excel
Thread ID: 15637 Message ID: 15719 # Views: 5 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Saturday, September 28, 2002 12:54:38 AM         
   


> > 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.


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