Forum Discussion
Excel Formula: What am I doing wrong?
Hi Brains Trust, I am trying to convert an 8-digit reverse date text string in to dd/mm/yyyy date format. What am I doing wrong? Column A is 'Text', Column B is 'Date' set to dd/mm/yyyy. I just ne...
First convert text to any date format, then convert it to a real date value. Finally apply your desired date format to display it.
=--TEXT(A2,"0000\/00\/00")