My problem is as follows;
I have a CSV file and one of the fields contains numbers such as mobile telephone numbers; when I open the csv file in excel to edit it the numbers are represented thus; 447800707414 represented as 4.47801E+11.
Is there a way I can turn off this feature in excel which automatically reformats the number? I cannot format the columns as it is a CSV file and only stores the data, not the format information.
Many thanks for any advice given.