Add Text prior to fraction

Originally Posted by MrShorty

It is still not clear to me what your smallest interval will be. Most rulers will be either 1/8 or 1/16, but I have seen 1/32 rulers. I am still inclined to use an MROUND() [or maybe CEILING() if you always want to round up] function MROUND() help file: https://support.office.com/en-us/art...b-d2d5b3baf427

I am also not sure if you need the "approximately " to be a part of the text string not. Remember that number formatting can be used to display that kind of text, but it does not become a part of the underlying cell value.

Assuming 1/8 inch precision and number formatting is acceptable for displaying the additional text, I would:
1) Add a helper column with =MROUND(A2,1/8)
2) Format this column as "approximately "# #/#\"

Will that work for you?

Thank you for your input sir. I will experiment with your provisions. As for measurement, if you go to a hardware store (USA), and pick up a 12" ruler, you will not see 32nds, you will see
1/16 all the way to 15/16
1/8 all the way to 7/8
1/4 all the way to 3/4
1/2
1"

These are the (common) measurements that the designers use in my industry. By use of (Approximately), this tells the customer exactly that.
If an item is not (exactly) 3/8" and it's really 5/16", well it's (Approximate)
Now if we can get those decimals to be EXACT, GREAT! I love it! But I can only work from the decimals provided, as you will see in
the example sheet provided. If by placing text in the cell, along with the fraction, is not good practice, then what is the better
solution? This information is going into a website, so once I have the correct formula, and it works, I then convert that cell to the value
only, and import to web. Thus far, I have seen great progress from a few here, but the formulas provided do not yet conquer
the fraction variations. Again, I will try yours to see if I can get better results.

MrShorty's much simpler suggestion can be adapted to 1/16

Originally Posted by MrShorty

1) Add a helper column with =MROUND(A2,1/8)
2) Format this column as "approximately "# #/#\"

I did try this method previously, but using 1/128 as the accuracy level, which was still returning some denominators not fitting to your scale, I should have revisited this option when you told us that you only needed to go down to 1/16, had I done so, I would have reiterated MrShorty's post instead of revising my formula.

Formula =MROUND(A2,1/16)
Custom format "approximately -" # ##/##\"

Gives the same results as the long formula that I provided.

However, the long formula does not go to waste, there may be occasions when somebody needs fractions aligned to a specific scale where mround and formatting do not work as needed.