Importing csv file values as text Differences

+The specific problem:

-
+

+Getting a csv file with the following data to display the data as text:

+

+1.234%,12.433%,1.2%

+

+Ordinarily, Excel would convert the values to percentages and display it with the standard percentage format (2 decimal places).

+

+The solution:

+

+In order to get excel to recognize the data as text, use the following format:

+

+="1.234%",="12.433%",="1.2%"

+

+Make sure that there are no space between the = and the first "

+

+Relevant thread:

+http://www.ozoneasylum.com/23206
+

+(Created by silence on 09-30-2004 09:37)