Hello,
I need help with a simple DATE converter. I have:
02/01/2018
22/03/2019
I want
2018-01-02
2019-03-22
I use this code:
But it does not work, how come? What am I missing? Even formatting (RIGHT CLICK -> FORMAT CELLS) does not work.
I need help with a simple DATE converter. I have:
02/01/2018
22/03/2019
I want
2018-01-02
2019-03-22
I use this code:
VBA Code:
=TEXT(A1, "yyyy-mm-dd"),
But it does not work, how come? What am I missing? Even formatting (RIGHT CLICK -> FORMAT CELLS) does not work.