writing into excel sheets while keeping the leading zeros

Hello, is there any way to keep the leading zeros in my number while saving to excel sheet as a csv file? I should be getting 000 001 010 011 etc but in the excel sheet it is 0 1 10 11. How can I solve this?

[Adam]

Isn't that down to the Excel formatting if it is a number rather than a string?

[SSG_newbiecoder]

even if I give it as a string it is still the same

Answer 1

[Pawel Jastrzebski]

Following the:

https://uk.mathworks.com/matlabcentral/answers/93656-why-is-the-leading-zero-dropped-when-i-write-a-string-of-numbers-to-excel

you could use a similar method:

val1 = randi(1000,[20 1]);
val2 = rand(20,1);

val = val1.*val2

valWithZeros = num2str(val,'%09.3f')
valWithZeros = cellstr(valWithZeros)

for i=1:length(valWithZeros)
    valWithZeros{i} = strjoin({'''',valWithZeros{i}});
end

xlswrite('file.xlsx',valWithZeros)

Or pre-format your sheet and then copy the data to it from Matlab. If you need to repeat this action over many batches of data, make sure you first make a copy of the pre-formatted sheet and then overwrite it with Matlab:

Pre-formatted sheet:

The Matlab code:

val1 = randi(1000,[20 1]);
val2 = rand(20,1);

val = val1.*val2

xlswrite('file.xlsx',val,'Sheet2','B2:B21')

Output:

[SSG_newbiecoder]

Thank you for the help. It works for me