How do I convert a fraction to its true decimal, not a date no.

G

Guest

I have imported a file into excel with fractions. When I convert the
fractions to decimals, it converts to a date number. e.g. 3/1 converts to
39085 as it sees it not as 3 but as the 3rd January. Any ideas?
 
G

Guest

Try checking "Transition Formula Entry" in the Tools|Options Transition tab
then select the column, choose Data|Text to columns and click Finish. Uncheck
this option after.
 
G

Guest

Check the format of cells where you are impoting data make it number before
you import because by default excel will take those fractional values as
dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert decimal inches into feet and inches 4
Convert Decimal fractions to binary and vice versa 1
Excel How To Convert Decimal To Inches 2
How do I import fractions without data being converted to dates? 1
How do you convert a fraction to a decimal with 3 places 3
Coversion Of Fractions To Percentages 9
fractions to date 2
How to convert decimal year to date format in excel 2

Top