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
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.