Hi all
Your help would be much appreciated.
My bank statement shows dates in a weird format: 2018-05-13T13:53:50Z
I've used a series of formulae to convert this to standard UK format: 13/05/2018
I want it to be formatted as a date: 13 May 2018
However changing the formatting does nothing. The only way I can get this to show is to copy the cell, special paste value, then click in the formula bar for this cell, then click ENTER
I would have to go through every single entry (Over 3000), click in the formula bar, click enter...
Is there a way around this?
Thanks so much
Alex
Bookmarks