I have this file where in column A i have numbers that don't show the good format even it it is text"
Ex: i can have 2.01111E+11
instead of 201108000000
And also, in column D i have numbers where i just want to remove the 2 starts, one at the beginning and the one at the end.
How can i do that?
Thanks for your help.