How can I suppress that xlswrite automatically converts a double into a date?

1 次查看（过去 30 天）
NoPie4U
NoPie4U 2012-8-27
When I save a floating point number into an excel File with xlswrite() it automatically converts into a date. Can anybody tell me how I can suppress this?

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

回答（1 个）

Albert Yam
Albert Yam 2012-8-27
Can you give an example of what you are experiencing in the OP? I have had a date appear, for me, but for a different purpose (not floating point). This is how I got what I was looking for.
xlsname = 'testxls.xls';
writethis = {'1/94';... %this give Jan/94 = 1/1/94 = 34335(text)
'''1/94';... %what I needed
12.1;... %trying to replicate
'''12.1';... %but no problem
1.12;... %please
'''1.12'}; %give example
xlswrite(xlsname,writethis)

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by