In Excel, to "format number fields as text instead of scientific notation", select the entire column, press CTRL+1 (or CMD+1) and change the format to Text

https://www.excelhow.net/convert-sci...-in-excel.html
https://www.extendoffice.com/documen...n-to-text.html