fraction calculation

My goal is to calculate the diagonal measurement, in feet and inches, needed to square a building based on depth and width of the building. My formula is A= building depth in ft. and B= building width in ft. So A squared + B squared = C squared Calculate the square root of C squared (ft.) and...

The output of a program provides a fraction like 6519/231 . I need to convert this to a decimal. I tried going from "general" to "number" in the drop down tab, but it does nothng. I really need to be able to put an equal sign in front of every entry, but I have hundreds. Any advice?

Hello Community, I am making a report displaying survey data. There are scalar questions, multi questions, and categorical questions. I'd like to make fractions across these questions in one table using DAX measures. I'd like to know the percentage of replies on both categorical and multi...

Hey Everybody, So i have a unique problem, I'm using a find code to extract text and separate it out to individual cells. Then a macro solves an equation based on the extracted values. The problem is when i use fractions the macro will not solve, i attached a link to share the file. Any help...

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