Change the date format of stuborn imported data

[Charlietbh]

Hello,



I'm exporting reports froim QuickBooks Online to Excel 2013 and don't like the way the date format looks. Currently today would show as 16/03/2015 rather than 16 Mar 15, which I prefer. In previous versions of QuickBooks I could just run a macro to change the format of the exported dates by highlighting them and running:

' Date solution
'

'
Selection.NumberFormat = "[$-809]dd mmm yy;@"
End Sub

But now if I do that nothing changes unless I click on each sell and press F2 then Enter. I know it's only a cosmpetic thing but I'd appreciate any help.