Excel displaying unwanted date data

1 次查看（过去 30 天）
charles atlas
charles atlas 2011-7-26
I have an array of date data as shown:
dates=
'12/23/2011'
'12/23/2011'
'12/23/2011'
'12/23/2011'
'12/23/2011'
I want to find out how many values of date data I have and write it into excel, so I have this code:
num=1:length(dates);
num=num’;
xlswrite(‘file_1.xls’, num, ‘sheet1’, ‘A1’)
xlswrite(‘file_1.xls’, dates, ‘sheet1’, ‘B1’)
The dates end up being displayed in excel fine but the array of 1 to fine labeled "num" displays an array in excel that looks like this: 1/1/1900
1/2/1900
1/3/1900
1/4/1900
1/5/1900
Does anyone know how I would fix this?

请先登录，再回答此问题。

采纳的回答

the cyclist
the cyclist 2011-7-26
Excel is interpreting those cells as dates (e.g. one day from the start of 1-Jan-1900, etc.). Go into Excel and change the format of those cells from "date" to "number".

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by