MATLAB Answers

NoPie4U
0

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

Asked by NoPie4U
on 27 Aug 2012
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?

  0 Comments

Sign in to comment.

1 Answer

Answer by Albert Yam
on 27 Aug 2012

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)

  0 Comments

Sign in to comment.