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 ...
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
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
- Brilliant, that worked, thank you
- So would this make an us date appear in UK format too
That has nothing to do with it.