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.

Charlietbh,

Your code will alter the format for a date in number form. I suspect your stubborn dates are text?

If so you can easily convert them by selecting >> Data tab >> Text to columns >> Next Next Finish

Then run your code if you need.

Hope that helps.

Utterly perfect, thank you

You can even do without the Next-Next part...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post