Simple cell reference not blank

[Charlie]

Whenever I do a simple cell reference, e.g.

=A1

if A1 is blank the resultant cell shows a zero. I'm getting tired of

=IF(A1="","",A1)

Without changing the cell format is there a setting or different formula
syntax to make the resultant cell equal the source cell literally?

TIA
Charlie

[Charlie]

Judging by the volume of responses I guess the answer is "No."

=IF(Responses="","",Responses&"It is")

"Charlie" wrote:

> Whenever I do a simple cell reference, e.g.
>
> =A1
>
> if A1 is blank the resultant cell shows a zero. I'm getting tired of
>
> =IF(A1="","",A1)
>
> Without changing the cell format is there a setting or different formula
> syntax to make the resultant cell equal the source cell literally?
>
> TIA
> Charlie