0

I try to get inside cell of google sheets

enter image description here

I try 2^5, but it gives 25 or shows 2^5.

How should it be done?

Improve this question
1
  • Hi, welcome to WebApps. To do what you want , Google Sheets would have to support formatting characters as subscript/superscript; which, unfortunately, it does not.
    – Tedinoz
    Aug 2, 2022 at 2:32

1 Answer 1

Reset to default
1

Write this formula in a cell:

=2&char(8309)

this is the result: potenza

for other values ​​see the following table:

table

if your pc has a numeric keypad, you can also enter the values ​​manually. To enter a code, make sure Num Lock is on, press the ALT key, and type the number of that code (only the number) on the numeric keypad.

Improve this answer
2
  • thanks, but how can one type fast (each time look for the code of soo much numbers, make google sheets unusable) a lot of numbers and powers such as 1343.21^56/221, 1247778^(56/221) etc.. on Mac that have a numeric keypad.
    – Ben
    Aug 1, 2022 at 12:37
  • If you have to often enter powers, fractions, roots and other mathematical amenities, then you should build the equation in google docs and copy and paste it into a sheet cell
    – Daniele
    Aug 1, 2022 at 14:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.