Byron Sonnier Posted June 3, 2019 Share Posted June 3, 2019 Good afternoon. I'm attempting to represent fractions rather than decimals in a spot fire cross table. My data is in excel and is set as a fraction. when I pull up the column it auto represents in decimal format. How can I change that back to a fraction Link to comment Share on other sites More sharing options...
Donald Johnson Posted June 24, 2019 Share Posted June 24, 2019 Aneighth, or 1/8, is 0.125 in decimal. Divideby 0.125 to find the number of eighths,etc. Certain fractions have rounding problems, of course. Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted June 24, 2019 Share Posted June 24, 2019 Change the data in Excel to a string so that the fraction formatting can be retained. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now