Need Empty Cell Reference to be Blank

[cionnaith]

Hi.

I have cell on one worksheet (e.g. Worksheet 2) that is reading from a cell on another worksheet (e.g. Worksheet 1) and displaying as text. I have another cell doing the same thing, but is formatted for dates. In Worksheet 1 I used ='Worksheet 1'!A1 to read from the other cell, but if there is nothing in the cells on Worksheet 1, the Worksheet 2 cell displays a 0 for the case in which the cell is formatted for text and 1/0/1900 for the cells formatted for dates.

How do I make the cells on Worksheet 2 just remain blank if there is nothing to read in the Worksheet 1 cells?

Thank you in advance.

 

[Haseeb Avarakkan]

Hello, Try

=IF('Worksheet 1'!A1="","",'Worksheet 1'!A1)

Or,

Go to Format Cell >> Custom

General;-General;

 

[mikerickson]

To make a blank cell show as blank try =A1&""

Note that if A1 contains a number, the formula will return a text value.

 

[cionnaith]

Hello, Try

=IF('Worksheet 1'!A1="","",'Worksheet 1'!A1)

Or,

Go to Format Cell >> Custom

General;-General;

thank you. i used that. much appreciated!!