Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to prevent Excel converting imported fractions into dates
I am importing a table into Excel. The table is text and has columns which
include fractions such as 1/8, 3/16, 5/32, and also composite fractions such as "1 1/8", "2 3/4" (but without the quotes). Excel thinks these are dates and autoconverts them to a date serial number. Once this happens there is no way to recover the original fractions. I have tried preformatting the columns where the data will end up as 'Fraction' format, and 'Text' format but that makes no difference. Is there a simple way of stopping this behaviour? At present I am manually pre-processing the data in Word to put quote marks around the fractions so they are imported into excel as text. I can then use formulas to re-create the deired numerical fractions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) |