Zeros to blanks in Office 2010

  • Thread starter Thread starter janmd
  • Start date Start date
J

janmd

I am importing data into Excel from Crystal Reports and would like to
set my Excel defaults so that all zeros are set to blanks - I can do
this for one worksheet but since I am bringing in new data on a
regular basis into different workbooks - I have to do it each time. Is
there a way round this so that the default setting for all workbooks
is that a zero will be displayed as a blank?

Thanks
 
Try the following.
open the default excel template (usually located on this location)
C:\Program Files\Microsoft Office\Office14\XLSTART\

Create a new workbook. Delete all but one of the worksheets by right clicking a tab and selecting Delete.

Change the settings to reflect the format you need.
Save and close the file. This should help.

Regards,
James

Submitted via EggHeadCafe
Microsoft .NET DataBase Access For Beginners
http://www.eggheadcafe.com/training...Server-Oracle-DB2-Informix-Query-Samples.aspx
 
Try the following.
open the default excel template  (usually located on this location)
C:\Program Files\Microsoft Office\Office14\XLSTART\

Create a new workbook. Delete all but one of the worksheets by right clicking a tab and selecting Delete.

Change the settings to reflect the format you need.
Save and close the file. This should help.

Regards,
James

Submitted via EggHeadCafe
Microsoft .NET DataBase Access For Beginnershttp://www.eggheadcafe.com/training-topic-area/Microsoft-NET-DataBase...
Click to expand...
Thanks very much - will give it a go.
 
Back
Top