[Scilab-users] mixed data type matrix

[Dang Ngoc Chan, Christophe]

Hello,

> De : fujimoto2005
> Envoyé : jeudi 23 mars 2017 09:55
>
> I want to make the matrix whose the first column has the date value such as
> 2007/5/1 which I can use it in Excel and whose second column has the numerical value such as 0.12.

Excel can convert dates to numbers, see e.g.

http://stackoverflow.com/questions/19721416/formula-to-convert-date-to-number

so you can represent a date as an integer the same way Excel does.

Then in Excel, you just have to change the cell format as date and it automatically shows up.

HTH

--
Christophe Dang Ngoc Chan
Mechanical calculation engineer
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.