Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Symbols on the keyboard are not the symbols on the screen.... Lisha Excel Discussion (Misc queries) 2 May 22nd 10 07:29 AM
Symbols used in excel SarahN Excel Discussion (Misc queries) 6 May 21st 10 08:15 AM
Excel Symbols randrews13 Excel Discussion (Misc queries) 2 May 23rd 06 04:34 AM
excel symbols ally Excel Worksheet Functions 1 May 14th 06 11:56 AM
excel symbols Bernard V Liengme Excel Programming 0 July 9th 03 02:40 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"