Format numbers in spreasheet

Hi!I would like to format a spreadsheet because it has wrong values and I can't create the right graph(no commas in some cells,for example the number 657667 intead of 65.7667).I tried to format the excel file first and it showed the correct values. I saved it and I imported the data in matlab ,but once again the wrong values appeared. Any help?

**These data need to get corrected as I have to do some calculations before the graph. For example:

A=1018,637 and B=917,5432 and y=A/B=1.11017. So , the value for y-axis is 1.11017. In fact the value I get is 11017 which is wrong!! **Any help please!!

[Walter Roberson]

This may be a difficult problem to deal with, as it deals with whether the decimal separator is comma or period in the file itself.

Is your spreadsheet .xls or .xlsx ? Can you attach a sample of it?

Answer 1

[Chayban Ghabech]

Hello Sofia,

Please upload your excel file.

Or send it via email:

[e-mail]

I have faced similar problems before.

Hopefully i can help.

Answer 2

[Image Analyst]

You can create an Excel template, with all the proper formatting and appearance. Then copy it to the file you want for output and call xlswrite() to put the data into the properly formatted file:

copyfile(templateFileName, thisFileName); % Create output file from template.
xlswrite(thisFileName, yourData, sheet, cellReference);