74674982327500000000 = 7.47E+19 in Excel become 07467498232750E7 in SQL Big Query. The “E” becomes an alphabet instead of the multiplication

74674982327500000000 = 7.47E+19 in Excel become 07467498232750E7 in SQL Big Query. The “E” becomes an alphabet instead of the multiplication

I need the “E” to multiply the number instead of being an alphabet because I want to filter based on their length. The number belongs to a column whose schema is set to strings because most of the value are unique ids made up of a combination of alphabets and numbers. Only a few of them wrongly made up of just numbers.

Excel

SQL

Mary Desilva