79150295

Date: 2024-11-02 09:03:41
Score: 2.5
Natty:
Report link

Following on from @Michal I used:

=TEXT(SUBSTITUTE(X2, ".", "/"), "dd/mm/yyyy")

Reasons:
  • Low length (1.5):
  • No code block (0.5):
  • User mentioned (1): @Michal
  • Self-answer (0.5):
  • High reputation (-1):
Posted by: elksie5000