General information
Category:
COM/DCOM and OLE Automation
.Columns("A:A").NumberFormat = "0;-0;;@"
>I need to hide the zero values on an Excel file that I'm creating from VFP. I cannot find a reference to this property in the excellent book "Office Automation". I have also opened the VB macro editor for Excel on files where I am changing the view setting for zeros but I don't see any property listed in the VB macro editor that seems linked to showing the zeros. In Excel 97 I can hide them manually by going to \Options\View\Zero Values and unchecking the Zero Values box. I am thinking it might be a workbook property.
>
>TIA.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only