Need Special Characters In Formulas (97)

Topic

New Reply

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

Reply | Quote

Replies

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”?

Reply | Quote

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

Ronny

Reply | Quote

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 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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

http://www.wopr.com/cgi-bin/w3t/showthread…amp;Main=128269%5B/url%5D

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

Reply | Quote

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

Ronny

Reply | Quote