Using = to another sheet, how to make blank cells show nothing

Blank cells show nothing.xlsx

In the real file I am working on there are several Columns of random information which I am trying to break down. Therefore I pulled only certain columns of information to "sheet2" by simply using =sheet1A3. I copied this down the column in sheet two and for the most part got the results I wanted. So when more information is added to Sheet1 it automatically is on Sheet 2.

However, when I do copy the formula =Sheet1A3 down to lets say row 40, when sheet 1 only has 10 rows currently filled in, my list shows 1/0/1900 for the date and 0 for the currency on the empty rows.

It seems like a fairly simple task to get these to just show blank cells until an actual value is added to the appropriate row in Sheet 1, but I just can't figure it out.

Thank you so much! This worked like a charm

I knew it wasn't that difficult!