Excel displaying unwanted date data
3 views (last 30 days)
Show older comments
charles atlas on 26 Jul 2011
I have an array of date data as shown:
I want to find out how many values of date data I have and write it into excel, so I have this code:
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
Does anyone know how I would fix this?
the cyclist on 26 Jul 2011
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".
More Answers (0)
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!