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.

[jeffreybrown]

Why not use a custom function which will mask the zero's

0;;;@

[anonymust]

Muchos Gracias Jeff,

But can you explain how this works and why?

I dont get the semicolon and "at sign" for masking.

[jeffreybrown]

De nada

With a custom format there are 4 arguments.

First >> positive number
Second >> negative number
Third >> a zero value
Fourth >> text

Semi-colons are just the seperators for the 4 arguments and the '@' sign will allow text to show

Maybe this will give you more info...

http://peltiertech.com/Excel/NumberFormats.html