Once I changed my region (in Windows control panel) all magically worked!
Those issues with
- localized versions of the operating system or the software
- the syntax of dates and times
- varying shortcuts
are the real nightmare in Excel.
Yes Rory. That was the last thing I tried
=TEXT(A2,"dd/mm/yy") and I get an error.
Maybe just a matter of fixing the local date to the region.
I will try harder
Hi Rory, I might be silly but I only know how to do it manually. I'm looking for a formula that will do it automatically
I'm struggling with this if anyone can help.
Thanks a lot