ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i add the squared symbol to a number (https://www.excelbanter.com/excel-discussion-misc-queries/38062-how-do-i-add-squared-symbol-number.html)

mike

How do i add the squared symbol to a number
 
How do i add the squared symbol to a number

Steve Yandl

One way to produce the exponent 2 is to hold the Alt key down while pressing
0178 (on the number keypad, not the top row of your keyboard).

Steve


"mike" wrote in message
...
How do i add the squared symbol to a number




bj

Do you want to square the number ? [ num^2 will square the number]
do you want to show that a number is squared in a text line?
enter the number with the 2 right after it. Select the 2 and <format<cell
and select Superscript.


"mike" wrote:

How do i add the squared symbol to a number


Gary's Student

In a formula use =A1^2 to square A1.
In text use 2, but format the font of the 2 as superscript.
--
Gary's Student


"mike" wrote:

How do i add the squared symbol to a number



All times are GMT +1. The time now is 05:56 PM.

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