=If(E3 = "00/01/1900", "", E3)
If that does not work you need to check the cell value that is coming back as 00/01/1900 and put that in the formula.
so,
=If(E3 = 0, "", E3)
=If(E3 = "00/01/1900", "", E3)
If that does not work you need to check the cell value that is coming back as 00/01/1900 and put that in the formula.
so,
=If(E3 = 0, "", E3)
DP978
Many thanks that worked with the zero option
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks