How to copy blank cells but not return '0'

I want to copy cells from another worksheet, but if there are empty cells in the worksheet I am copying from, then it registers as a '0' in the worksheet the data is copied to.

In Worksheet A, A1 is empty, but when i use ='A'!A1, A1 in worksheet 2 is '0'

How can I get Excel to leave cells in both worksheets empty?

thanks, it worked!

While I was waiting for someone to reply, I just figured out that I needed a rank formula that ignored blank cells.

Also,

Will a blank-cell-ignoring rank formula work with my current descending formula which ignores '0's

=OFFSET(S$6,MATCH(SMALL(V$6:V$25,ROW()-ROW(V$6)+1),V$6:V$25,0)-1,0)

or will I have to get a new descending rank formula that ignores blank cells instead?