How convert date and time to number that excel will recognize the really date and time?

I need to convert a column that contains dates to numbers and a column that contains time to number also in order to be able to perform some processes. I tried x2mdate and datenum but when I open the file with excel and I convert it again to date and time respectively the excel doesn't recognize the real dates and times. What is my wrong?

Thank you in advance

[Peter Perkins]

Kelly, I don't think you've provided enough information to answer your question. What exactly are your dates and times stored as, you writing to a file or working within MATLAB, and so on.

Answer 1

[George]

Use datetime and writetable

A = table(datetime());
writetable(A, 'myfile.xlsx');

[Kelly Kyriakou]

I can use this function provided thath date and time is one string. In my case thesen are seperate strings and the functions gives me error that cannot recognize the of the date/time strings.

[Walter Roberson]

If the dates and times are in two cell arrays, then you can use

strjoin(dates_cell(:), {' '}, times_cell(:))

[George]

In addition to Walter's comment you can look at the datetime format properties.