Matt,

It's an IEEE limitation that only allows 256 fonts in a
font table. Maybe it would be nice if there were a math
font which expanded some of the suggestions you had and
eliminated others. But that would still be limited. If
you are not set on using CHAR() to accomplish this, there
is another alternative.

Suppose you want to raise X to the 6th power, subtract 1
and take the result to the -4 power. Simply type into a
cell:
(X6-1)-4
Then highlight the '6' in the formula bar, select
Format\Cells and check Superscript. Do the same for '-
4'. You will then get the expression to show up as
desired with powers of 6 and -4.

Steve

-----Original Message-----
Hi

as a maths teacher - the symbols from the CHAR function
are real useful

unfortunately Excel only provides the text powers of
0,1,2,3 and limited
numbers of fractions less than 1 from

CHAR(185)CHAR(179)CHAR(178) CHAR(188)CHAR(189)CHAR(190)

and thats it!!

obviously powers of 4,5,6 and -1, -2 etc would be great
and improper
fractions

anyone have a solution to this or do we have to live with
this
limitation?


Regards

matt



*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.