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;
Bookmarks