Spreadsheet Cell Data Type after Excel importing

After loading an Excel file into the spreadsheet widget, it seems that a value like ‘19E01’ becomes a Scientific type resulting in this Infinity value in the Spreadsheet widget, how do i set all the cells to be text instead without changing first in Excel? thank you very much for the help!

Screenshot 2023-08-28 235737

1 Like