Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel symbols
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Symbols on the keyboard are not the symbols on the screen.... | Excel Discussion (Misc queries) | |||
Symbols used in excel | Excel Discussion (Misc queries) | |||
Excel Symbols | Excel Discussion (Misc queries) | |||
excel symbols | Excel Worksheet Functions | |||
excel symbols | Excel Programming |