Hi, p45cal
Thanks for responding:-
1. The .csv is provided to us by our IT team
2. I have attached a sample...the yellows are being formatted as a date and the greens have retained their formatting. The green is the desired result.
We are using Excel 2016, if that helps?
Thanks
Lynn
|