sql Archives - Women Like That

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

13 Dec 21 Mary Desilva

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…