ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can you format so you could write x squared using exponents? (https://www.excelbanter.com/excel-discussion-misc-queries/66701-how-can-you-format-so-you-could-write-x-squared-using-exponents.html)

Susan Kerlin

How can you format so you could write x squared using exponents?
 
I want to be able to type x squared using exponents, but not with the caret.

Gary''s Student

How can you format so you could write x squared using exponents?
 
Select a cell and enter:

'x2

then in the formula bar highlight only the 2 and pull-down:
Format Cells... and check superscript.
--
Gary's Student


"Susan Kerlin" wrote:

I want to be able to type x squared using exponents, but not with the caret.


Gord Dibben

How can you format so you could write x squared using exponents?
 
Susan

To format text like x with the exponent of 2 FormatCellsNumberCustom

Enter the @ sign followed by ALT + 0178(on the numpad)

To format numbers use 0 followed by the ALT + 0178


Gord Dibben MS Excel MVP

On Sun, 22 Jan 2006 12:31:02 -0800, Susan Kerlin <Susan
wrote:

I want to be able to type x squared using exponents, but not with the caret.




All times are GMT +1. The time now is 02:00 AM.

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