I'm attempting to export some GMT time tagged data to Excel, that looks like this;
21:48:52.03 78532.0390000000 0
21:48:52.80 78532.8050000000 0
21:48:53.55 78533.5550000000 1
But when I export it to Excel, the result is this;
48:52.03 78532.0390000000 0
48:52.80 78532.8050000000 0
48:53.55 78533.5550000000 1
I'm attempting to format column E's number format with the following:
Activesheet.Columns.Item('E').NumberFormat='hh:mm:ss.000';
I'm using MATLAB 2015A and Excel 2010.
In looking at the on-line documentation, this should work - and does with older versions of MATLAB (2010a) and Excel (2003).
I've tried different number format combinations. None of which work and I get the exact result (above) every time.
Am I missing something subtle or just implementing this incorrectly?
Thank you.