Excel Formulas

[markS160]

HI Im trying to use this formula =('Data Entry'!B34) to retrieve data from another part of the spreadsheet, but if the cell is blank it give me a Zero in the cell.  How do i get this to show a blank instead when there is no data in the field im retrieving from.

Thanks

Mark

[#2]

Modify your formula like this:
=IF(‘Data Entry’!B34=“”,
“”,
‘Data Entry’!B34)

[#3]

@markS160 

Another way is to select linked cells, Ctrl+1 and apply custom format

General;;

(or which one you use for numbers instead of General)