| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| How to write a "Text" or date custom format | Excel Worksheet Functions | |||
Linear Mode
