ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I enter postccripts in an Exce, such as for powers of a nu (https://www.excelbanter.com/excel-worksheet-functions/128463-how-do-i-enter-postccripts-exce-such-powers-nu.html)

Odiesdad

How do I enter postccripts in an Exce, such as for powers of a nu
 
I need to add a postscript number, such as the power of a number, in either
Word or Exell How can I do this. . .

T. Valko

How do I enter postccripts in an Exce, such as for powers of a nu
 
Suppose you want 10^2 in cell A1

First, format cell as TEXT (applying super/subscript only works on TEXT)

Type 10 then right click and select Format CellsSuperscriptOK, type in the
2 then hit ENTER.

Kind of a pita, but that's how it's done.

Biff

"Odiesdad" wrote in message
...
I need to add a postscript number, such as the power of a number, in either
Word or Exell How can I do this. . .




Chip Pearson

How do I enter postccripts in an Exce, such as for powers of a nu
 
It should be noted that this will work only with cells containing static,
literal values. There is no way to do this if the cell has a formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"T. Valko" wrote in message
...
Suppose you want 10^2 in cell A1

First, format cell as TEXT (applying super/subscript only works on TEXT)

Type 10 then right click and select Format CellsSuperscriptOK, type in
the 2 then hit ENTER.

Kind of a pita, but that's how it's done.

Biff

"Odiesdad" wrote in message
...
I need to add a postscript number, such as the power of a number, in
either
Word or Exell How can I do this. . .







All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com