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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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 fractions to binary and vice versa 1
fractions to date 2
convert decimal inches into feet and inches 4
Best Way to Convert CSV Files to vCard? 1
Fractions to Decimals problem 1
How to convert a .msg File? 2
How Can I Convert MBOX to HTML File? 0
problem with fractions to decimal 1

Back
Top