Forum Discussion
Solved
How to not display 1900 in the filter when i have used conditional formatting to not display date
Hi
I have blank dates that show as 00/01/1900.
I have used conditional formatting (custom ;;;) to show them as blanks.
But when I use the filter they still show as 1900 instead of blank.
How do i stop this and return blank?
Many thanks
It's a refreshable so replacing not really an option but I'll check if these a formula. I think there's =(original date column)+1-1
6 Replies
The values 00/01/1900 aren't real blanks, but zeros.
Does the Gas Expiry column contain formulas? If so, change the formulas to return "" instead of 0.
Otherwise, select the column and replace 00/01/1900 with nothing (blank).
It's a refreshable so replacing not really an option but I'll check if these a formula. I think there's =(original date column)+1-1
