| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert a fraction to its true decimal, not a date no.
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert a fraction to its true decimal, not a date no.
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. "2HatsMcHattie" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert a fraction to its true decimal, not a date no.
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. "2HatsMcHattie" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert fraction to decimal | Excel Discussion (Misc queries) | |||
| Excel. decimal convert date | Excel Discussion (Misc queries) | |||
| leave the decimal fraction | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| convert decimal to inch & fraction | Excel Discussion (Misc queries) | |||
Linear Mode
