How to force a number to be displayed as a string?

2 次查看（过去 30 天）
Leon
Leon 2018-1-29
评论： Leon 2018-1-29
I have a list of numbers (6 digits) in the Excel. I read them as strings.
[~, ~, A] = xlsread('filename.xlsx');
The issue is that these number export into my txt file as scientific notation. For example, 123456 would appear as 1.23456 x 10^6. Of course, that doesn't work for a link. How do I force it so that it will be outputed as a normal number?
fprintf(fid, '<td widtd="6%%"><a href="https://www.abcdef.com/%s">%s</a></td>\n', A{i,9}, A{i,9});

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

采纳的回答

Benjamin Kraus
Benjamin Kraus 2018-1-29
编辑：Benjamin Kraus 2018-1-29
Are the numbers stored as numbers or character vectors in MATLAB?
class(A{i,9}) % double or char?
If the answer is double, then you want to use %d in your format string instead of %s.
fprintf(fid, '<td width="6%%"><a href="https://www.abcdef.com/%d">%d</a></td>\n', A{i,9}, A{i,9});

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Standard File Formats 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by