Help need for a small problem in excel

[springy2003]

Hi, I need help on this tiny problem I am having in excel.

What I want to do is transfer one bit of information in one cell, for example from Sheet 1, cell A1, to another cell in another sheet, eg, Sheet 2 and cell A1. At the moment, I am using <b>='Sheet1'!A1</b> in sheet 2, A1, but if no data is entered in Sheet 1, A1, there is a value of 0, in the cell on the other sheet. Does anyone know how to get rid of that 0? I have try looking at formatting the cell, but that doesn't work. Can someone please help me on this tiny problem. Thank You.

 

[xlbo]

=if(sheet1!A1=&quot;&quot;,&quot;&quot;,sheet1!A1)
should do the trick nicely Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[springy2003]

WOW, thanks so much. I needed that little thing. Can't believe I didn't thought of that!!

Thanks So much!!!!!