IF function to remove 0s

[thomas.szwed]

Hello,

I have a sheet that picks up data from another. The formula is the

='Master Data'!AW35

But when there is no value to return it returns a 0. Is there anway i can change this so that it is just blank.???

Thanks

[NBVC]

You can custom format the cell to hide the 0.

Format|Cells and select Custom from the Number tab...

enter:
General;-0;