Importing csv file values as text

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)