Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Computer Support (http://www.velocityreviews.com/forums/f33-computer-support.html)
-   -   Superscript in Excel (http://www.velocityreviews.com/forums/t203237-superscript-in-excel.html)

MGT 07-07-2004 02:22 PM

Superscript in Excel
 
Is it possible to show supersript in a text entry in excel for example the
symbol for H2O or Cubic metres - m3??

TIA

Mick



Corticium Griseoeffusum 07-07-2004 02:55 PM

Re: Superscript in Excel
 
MGT wrote:
> Is it possible to show supersript in a text entry in excel for
> example the symbol for H2O or Cubic metres - m3??


That's a bit of a bugger and depends on the version of Excel you have. As a
general rule the style options you need are not available when editing
inside a cell, though the font size and bold, underline, italic options are.
That means you can type large and small fonts in a cell, with bold,
underline or italic anywhere, but not superscript or subscript.

The easiest way around it is, assuming that you also have Word, to type the
text as you want it in Word then copy/paste the formatted text into the cell
where you want the superscript text to appear. The cell should be set to
type Text.

You can't even copy super/subscript out of a formatted comment and paste it
into a cell. It will lose its formatting every time.





SgtMinor 07-07-2004 03:19 PM

Re: Superscript in Excel
 
MGT wrote:
>
> Is it possible to show supersript in a text entry in excel for example the
> symbol for H2O or Cubic metres - m3??
>
> TIA
>
> Mick


Yes. Highlight the character you wish to show in subscript or
superscript, go to Format Cell > Text, and select the option.

The Excel help function (f1) could've told you the same.


All times are GMT. The time now is 04:28 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.