Exponential configurations
 

How do I formate a cell to show a certain number to a certain power

So for instance I want to show the value of 10 to the 2nd power
or 13 to the 5th power or whatever my values are.

Thanks

Miami wrote...
How do I formate a cell to show a certain number to a certain power

So for instance I want to show the value of 10 to the 2nd power
or 13 to the 5th power or whatever my values are.

Excel lacks this functionality (superscripts). You could create the
text you want to display in Word, then copy it in word and paste it as
a picture into Excel.

Miami

Value is not a format.

=4^3 returns 64

=5^3 returns 125

Is this what you mean?


Gord Dibben Excel MVP

On Thu, 3 Feb 2005 18:14:03 -0700, "Miami" wrote:

How do I formate a cell to show a certain number to a certain power

So for instance I want to show the value of 10 to the 2nd power
or 13 to the 5th power or whatever my values are.

Thanks