formula =Cell returns 0 if cell is empty - can it be blank?

You can use something like:

Formula:

=IF(Sheet2!A1="","",Sheet2!A1)

or, if the data is always alphanumeric, you can use:

Formula:

=Sheet2!A1&""

If you use the second one with a numeric value, it will make it a text field. That is, it will still look like a number but it will be left aligned and some numeric calculations won't work.


Regards, TMS