@xld: The OP said "Data from cell A1 is a word."

I feel I should bow to your superior knowledge, but ...

I assume from that that he's getting a zero if the cell is blank and wants it to be blank. If the cell had a zero value, setting the option to not display zeroes would hide a valid return.

Am I missing something?

If it is always text, I guess the OP could also use =A1&"" to stop the zero value.

Regards, TMS