Do not display "0" from other sheet

[anonymust]

How can I get excel to display an cell with nothing in it?

I want both columns A and B on (sheet 2) to be the exact same as sheet one.
But
when I insert the =Sheet1!A1 and when i drag that function down the sheet all the cells on Sheet 1 that have no data comes up as " 0 " on sheet two.

I want to hide/ rid of all these 0's on sheet 2

P.s. Column A & B on sheet one are all Text fields (no numbers)

Thanka in advance.

 

[Joe4]

How about replacing:
=Sheet1!A1
with
=IF(Len(Sheet1!A1)>0,Sheet1!A1,"")

 

[jono19872006]

=if(isblank(Sheet1!A1),"",Sheet1!A1)

 

[BenMiller]

Or =CHOOSE(--(Sheet1!A1<>0)+1,"",Sheet1!A1)

 

[anonymust]

I actually used a mask to make my life easier,

So I basically formated the the colums with a custom mask

I used:

0;;;@

 

[anonymust]

=if(isblank(Sheet1!A1),"",Sheet1!A1)

I was trying to avoid an if statement But thanks for all your help.

 

[Joe4]

I was trying to avoid an if statement

Another way it to format the cells to hide the zero values. See here for details: http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP005199879.aspx