Importing fractions with proper format from CSV
 

I am having a slight issue with comma separated value files and
fractions. When opening a plain text file with lines like;

"Full Name","Ancestory"
"Sara Lee","1/2"

Excel converts the value of '1/2' into January 2nd, when it should
remain a fraction. Formatting the column for fractions then results in
the numeric value representing January 2nd (37988). The original
fraction at that point is entirely gone.

Placing an apostrophe (single-quote) in front of the fraction in the
CSV file causes the fraction to display without conversion, but the
apostrophe is not hidden unless I go through and manually touch each
cell (edit, then move on).

I realize this isn't technically "programming", but it still seemed to
fit this forum. Does anyone have any tips or information on how to
prevent this auto-conversion and have the fraction show by its self?

Thanks,
-Ross


---
Message posted from http://www.ExcelForum.com/