Hi, we work with many data files which are saved as CSV files. In some of our
files, the data values are numbers which themselves are comma seperated but
they are encapsulated within text quotes e.g. "25,99999".

When I double click the CSV file and Excel automatically loads the file, the
number format gets changed to 2,599,999 even though the original value was in
a text string. I know I can solve this problem using the import wizard but
when you are working with 30-50 of these files per day I do not want to use
the import wizard all the time.

does anyone have any ideas if I can change the default formatting of the
number that excel is applying?

Thanks!