how to raise a number in excel?
hi .....as we raise a number in word using shortcut crt **** plus is there any way to write a raise a number in excel.in short i want to write in excel 20 power 3 and it shows like this that 3 should be shown upper part of 20.......
- NahumLv 77 years agoFavorite Answer
You will have to use the Font tab in Format Cells to mark the 3 as superscript. The cell also has to be formatted as Text, or Excel will simply interpret the superscript as a regular number and turn it back to normal size.
In the case of superscript 3, there is also a ³ symbol you can add, available in most fonts. Keep in mind that Excel will not actually treat ³ as a numeric exponent—it just sees it as another text character, and will cause the entire value to be treated as text.
There is no shortcut, nor any command that you could add via the Quick Access toolbar, except through VBA.
In order to *calculate* an exponent, you can use the POWER() function or the ^ operator.
- garbo7441Lv 77 years ago
The two methods of raising a number to a power are the POWER function, as previously offered, or using the 'caret' symbol:
This will cube the value contained in cell A3. It is not necessary to apply the superscript to the power indicator.
Similarly if the power indicator is a negative number, the result will be 1 divided by the number raised to the power indicated. Thus, 10^-3 would result in 1/1000, or .001.
- KookiemonLv 67 years ago
There is no Super/Sub-script shortcut in Excel like there is in Word. You have to manually edit the Font options to switch back and forth. Press CTRL+Shift+F to bring up Font options, select Superscript, then type what you need to type. After you are doing, turn off Superscript using the aforementioned method.
- Anonymous5 years ago
It is definitely this ^ symbol . I use it all the time, so 4^3 is 4 cubed = 64.
- How do you think about the answers? You can sign in to vote the answer.
- SMACLv 47 years ago