Hello All
Hopefully a simple one for you here (driving me nuts)!
I have a spreadsheet which after perfroming a VLookup, has some cells showing "0". Now when I apply a 'date' format to the elevant columns, those cells which had '0' now show "00/01/1900". I have tried making only the cells "0" as blank cells, so that when I apply the date format, the blank cells remain blank and the other relevant dates format as expected. However, when I apply the code to remove only the cells containing "0", it actually removes all "0", so the good dates become messed up (i.e. 15/02/2014 becomes 15/2/214). I have tried all kinds of ways to do this automatically but failing big time.
Here is the code I am using before before applying the date format:
I have attached a copy of the spreadsheet just for ease of use.
Many thanks All
G1
Bookmarks