Trouble reading date/time with milliseconds using xlsread

I am using MATLAB version 2013b on a PC running Windows 7.

I have a spreadsheet that includes date/time in the following format: dd/mm/yyyy hh:mm:ss.fff such as 17/03/2014 0:24:22.875

When I read the spreadsheet using either xlsread or readtable, the time is read in as text but does not include the milliseconds (instead it rounds to the nearest second). For example, the above time is read in as '3/17/2014 12:24:23 AM'. I can not get it to read in the milliseconds.

I’ve tried:

[num,txt] = xlsread( spreadsheet, worksheet ) [num,txt,raw] = xlsread( spreadsheet, worksheet ) T = readtable( spreadsheet, ‘Sheet’, worksheet )

and none of them will read in the milliseconds.

[dpb]

If'en that's the behavior w/ xlsread, I'd guess your stuck unless you can save the actual text and convert to ML datenum internally or save as numeric in Excel and then do the base reference conversion.

Don't think there's any way to change the interior behavior of xlsread; it's gonna' do what it's gonna' do, unfortunately.

[Anderson]

I'm having this exact problem. Has anyone found a workaround?

[dpb]

I don't recall this thread; can't believe I didn't try it at the time but apparently didn't owing to the difference in versions. W/ R2012b here it reads the full text string as entered in both the text and raw return fields as expected.

That's for a cell formatted as either 'General' or manually to match the actual data; it doesn't convert the latter to datenum.

But, the string is read in its entirety as I'd expect.