when i load excel file number data read as string in matlab

I use T = readtable('rawtrans1.xlsx') this command to load excel data . but found numeric data type declared in excel read as string in Matlab.So I can't do numeric calculation

[Geoff Hayes]

Kakoli - can you convert to a number using str2double? I see that T is a table so presumably you are accessing a certain row or column from it...

[Jeremy Hughes]

It would help to see the file.

If the numbers are stored as TEXT in the spreadsheet, READTABLE will read those as text. Otherwise, I'd expect those to be imported as DOUBLE.

[KAKOLI DEY]

No it can't work; it shows NAN

[Adriana Velasquez]

I'm having the same problem and I have the format for that column in Excel as number. I tried cientific too..but nothing..readtable is reading the values as string. Did you figure it out two years ago @KAKOLI DEY?

[Cris LaPierre]

As Jeremy said, we can be of more help if you share your file. Attach your spreadsheet to your post using the paperclip icon.

Otherwise, take a look at this page.