Help with Date Formatting

[yus786]

Hi

I have a VLookup that brings dates over from another sheet.

Only issue, is that any cell that has ZERO is coming over as 01/01/1900. I just want these cells to be blank?

How is that possible?

So any dates coming over as ZERO - i need the cell to be blank instead of 01/01/1900?

Thanks

EDIT: Actually solved it. I formatted the cell as dd/mm/yyyy;dd/mm/yyyy;