Get instant live expert help on I need help with fractions in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

In column B4:B16, it has fraction within them. For some reason, it will not add these fractions together.
Solved by B. Q. in 29 mins
hello, i want to do an average of fractions but do not understand how to do that
Solved by X. L. in 22 mins
I have a CSV student responses to questions on a math test. Some of the answers are input as fractions (3/5, etc.) When I open in excel, these fractions get converted to dates. If I change the format back to text or number, Excel changes it into its date code, instead of its value (3/5 becomes 45329 instead of .6 or 3/5) which is obviously not what I need. I have no control over the source data. Is there a way I can stop Excel from autoconverting 3/5 to date when I first open the file? I have Excel 2013.
Solved by B. U. in 30 mins
I need help with formatting cells with fractions. I want to be able to say change colour with any values above 3.5/5, but when I enter 4/5 it doesn't like that colour. Am I doing something wrong?
Solved by K. U. in 28 mins
i need help in dates in excel , how to count dates in excel ,
Solved by S. E. in 20 mins