Skip to main content
3 of 3
edited tags
george2079
  • 39.1k
  • 1
  • 44
  • 111

Importing numbers from Excel

I guess my problem is very simple but I could not find the solution by searching it.

I have a column in excel sheet (Sheet1 in Book1.xlsx) including student numbers as the following.

Student ID
2014512060
2013512024
2013512028

When I import these numbers from Excel to Mathematica by

Import["C:\\Book1.xlsx", {"Sheets", "Sheet1"}]

what I get is the following output.

{{"Student ID"}, {2.01451*10^9}, {2.01351*10^9}, {2.01351*10^9}}

However, I want to get the following output.

{{"Student ID"}, {2014512060}, {2013512024}, {2013512028}}

Question. How can I get the exact student numbers?

bkarpuz
  • 809
  • 5
  • 16