I have a program that takes an excel spreadsheet, reads in the values, and then makes a table out of the data. I work in decimal inch for all the spreadsheet calculations, but I need to convert the output to fractional inch. I currently take whatever number I wind up with, round it to the nearest .125, and then format the cell as a fraction up to two digits. This works as expected for any human reading the spreadsheet, but when the 3rd party program reads in the data it displays the underlying decimal number rather than the formatted fractional text.
As a quick example: Say I do whatever math I need to do and the final result I get is 23.382 and it's in cell R6. I go to whatever the desired output cell is and enter "=MROUND(R6,.125)", and this gives me 23.375. All is well so far. Now I format the cell as "Fraction up to two digits" and it displays 23 3/8. Perfect. I save the file and import it into the 3rd party program. Instead of grabbing the 23 3/8 text it has taken in the underlying number of 23.375.
My question is: How do I take a decimal number and actually convert it to fractional, not just format it as fractional? I can usually google my way out of these kinds of problems, but I am not having any luck accomplishing what I need to this time. I am sure some excel wizard has solved this 20 years ago, I just can't find it. I of course appreciate any help in advance.
Bookmarks