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

2

2HatsMcHattie

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?
 
L

Lori

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.
 
H

HASSAN SHAREEF

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

Excel does not accept text format! 0
Fraction to Decimal 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How do you convert a fraction to a decimal with 3 places 3
Need to open eer file without converting 8-7440 to a date? 1
fractions to date 2
Numaric to Inword in excel by VB 1
how do i stop excel from converting numbers entered into a date 2

Top