Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format numbers as architectural fractions (1/16,1/8,1/4 ) | Excel Discussion (Misc queries) | |||
How do I Format fractions as fraction characters in Excel 2003? | Excel Discussion (Misc queries) | |||
Cond Format & Proper | Excel Discussion (Misc queries) | |||
Fractions in 16ths format - reducing to LCD | Excel Discussion (Misc queries) | |||
Changing proper fractions to improper. | Excel Discussion (Misc queries) |