MATLAB Answers

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

3 views (last 30 days)
NoPie4U
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.

Answers (1)

Albert Yam
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.

Community Treasure Hunt

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

Start Hunting!