I have a problem that I can't fix in Excel 2016.
An imported table has columns of fractions that are formatted as TEXT.
I need to convert those TEXT fractions into decimal NUMBERS.
I read a number of suggestions and tried them, but nothing works.
I even tried my own stuff, but that didn't work.
Here's what I tried that came close to working, but failed:
Copy a column of TEXT fractions, and past it into NotePad to clean-off all formatting.
Then open a new spreadsheet and format a column as FRACTION.
Then copy the NotePad column of 'fractions' and past that into the spreadsheet column that's formatted as FRACTION.
Result: All the numbers convert to fractions EXCEPT 1/2 and 3/4, which convert to DATES.
Then I select that column and format it as DECIMAL, and all the non-dates format correctly.
What is happening here?
How can I fix it?
Thanx ... Chris