fraction

This is driving me absolutely crazy. Whenever I paste a table of data to Excel, it automatically converts fractions to dates. First of all, this is ludicrous, and shouldn't be done automatically. Secondly, I can't find a way to stop it. I read several forums which said to change the number...

Good day, If i have a value 0,366 in cell A1 and i format it as a fracture with 3 positions i will get 42/125 so far so good. But now i want to split this value (42/125) in two different colums, so i want to see 42 in column B and 125 in Column C I just can't get it.... I hope anybody can...

Hello everyone, below is an example of the problem I am having. When I add using the sum formula, Excel keeps giving me a 1 for an answer. Anyone have a better formula for adding fractions to yield a fraction? Thanks! <colgroup><col><col></colgroup><tbody> 1/2 + 3/5 1 </tbody>

Hi, I want to substract OD with ID to get Wall Thickness, the problem is, fractions are stored in text format and if clear the format then excel autoformat some fractions to date i.e 3/4 to 4-Mar. Another problem is if i do not convert the text format then substraction formula wont work. I...

How do I stop 6/18 from reducing to 1/3, even though it's formatted to two digits.