Add = first in every cell
So i have imported lots of data from another program where large numbers where written as 4565E5 for example now if i add a = in front google sheets recognise it as an exponential and makes it into 4565*10^5 like i want, but i cant manually write an = in front of every cell, is there a good way to do this easily?