Zeros to blanks in Office 2010

[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

 

[James PrabhatKiran]

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

 

[janmd]

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

Thanks very much - will give it a go.