T
tdr_ross
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
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