# Thread: Need Special Characters In Formulas (97)

1. ## Need Special Characters In Formulas (97)

I want to write a formula to display statistical results. For example, if cell B1 calculates the left side of a mean confidence interval and cell B2 the right, then I could display the confidence interval using the formula:

=B1&" <= u <= "&B2

Only I want to use the less than or equal symbol and the mue symbold rather than the ones shown here.

I can figure out how to do that when the symbols are all available in Times New Roman (or any single font) as they are in this example. However, that is not always the case. For example, to do a chi-square confidence interval, I need the less than or equal, chi-square, and squared two symbols and no font (on my machine) has all these symbols.

To make it a little more complex, I want to be able to share the resulting worksheets with my students, who may not have exactly the same fonts on their machines as I do so I need to stick to the very basic fonts.

Any suggestions?
Ronny

2. ## Re: Need Special Characters In Formulas (97)

Can you post pictures of these symbols? Mu (0109), less-than-or-equal-to (0163) and chi (0099) characters are in Symbol, which all Windows users should have. Square will have to come from another font, all users should have Arial, TimesNR and MS Sans-serif. I'm not familiar "squared two"?

3. ## Re: Need Special Characters In Formulas (97)

A very simple method for >= or <= is to type just > or < and apply the underline format to the cell. I'm afraid I don't have a solution for the other symbols.

4. ## Re: Need Special Characters In Formulas (97)

Ronny,

Take a look at this macro which was written to help create math equations in Excel It uses special code characters in your equation to convert text to super, sub, italic, or characters from the Symbol font. You could probably customize it to suit your needs.

As it stands it doesn't run on cells with formulas. but if you disable that line it will run and convert the formula to a value.

Regards
Ken

5. ## Re: Need Special Characters In Formulas (97)

What I meant by two squared was the tiny two in the top half of the frame that some fonts offer.

Ronny

6. ## Re: Need Special Characters In Formulas (97)

This will not work in a formula since you are not allowed to format individual characters in a formula.

7. ## Re: Need Special Characters In Formulas (97)

This approach will not work for me as I need the formulas to remain dynamic, not be converted to text strings.

Ronny

8. ## Re: Need Special Characters In Formulas (97)

I can't find a simpler way to do this (which only means -I- can' find a simpler way) so following on Rory's <!post=Post,118796>Post<!/post> attached is a PKZipped WB containing all the Unicodes which will display in XL 97, and functions for the characters you need to display. Note that they may not print.

9. ## Re: Need Special Characters In Formulas (97)

Could you do it by using 3 cells rather than 1?
e.g. put the first value, right-aligned, in J1, the chi squared or whatever, centre-aligned and formatted using whatever fonts are available in K1 and the second value, left-aligned, in L1

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•