Calibri font 3/8 character full size#
You can then refer to the full size formula in the final else, making it the last resort.ĭon’t forget that you have to format this field with one of the fonts that support these symbols. If that would be rare but legitimate you might want to include the original (full size) fraction formula in the report. What should the formula do if the decimal value doesn’t match one of the 24 fractions in the formula? If that would be considered a mistake in the data then you can print an error message after the final ‘else’. Including more decimal places requires a more precise match. You may even need to round the incoming value before using that in this formula. This number should match the the number of decimals in the field you are converting. 62485? I set the rounding in this example to 3 decimals but you can adjust that by changing the ‘D’ variable in the first line. For instance the formula will always print 5/8 if the decimal is. You have to decide how precise the decimal match has to be. These I created with other special characters that seem to be designed for creating fractions.īut there are several things you have to keep in mind with this technique: I then extended it to include the eight odd numerators over 16. The formula below will tap into these characters for the corresponding decimal values. I found single-character symbols for the 15 most common fractions – those that have a denominator of 2,3,4,5,6 or 8. For instance the Unicode value CHRW(8541) is the character for the fraction symbol “5/8” in several fonts.
Then I found that several fonts have several common fractions as a single character. Recently a customer wanted me to shrink the fraction so it would look like a true fraction.Īt first I started looking for super script and subscript characters. But the output used full size characters combined with a slash. A few years a back I posted a formula for converting a decimal value into a fraction.