Commas being stripped from cells
Cells with a relatively low number of commas (4 in my reference sheet) are having the commas stripped. where as cells with more (8 in my reference sheet) are retaining them.
I.e:
181,218,131,645
is being stripped back to 181218131645
when i load the sheet
but longer ones, I.e:
4172,8443,443,80,4002,8009,8530,22443,32111
are staying as they are in the original spreadsheet.
sheet is being loaded with pandas:
pd.read_excel(file, engine='openpyxl', sheet_name = sheet1)