Why does Excel translate `= 10 ** - 2` into` = 0.1`?

Question

Try pasting =10**-2into a cell in MS Excel. After pressing Enter, he turns it into =0.1. I can't seem to find the documentation for **, but it looks like a rather strange operator, like exponentiality, that cannot be used in an Excel formula (for example, it =A1**A2is invalid).

If this operator is not an exponentiation operator, what is it?

(NB: mathematically, 10 ^-2 = 0.01, not 0.1)

Answer 1

** matches E

= 4E3 == 4 ** 3 == 4000

Answer 2

, A**B A B A**B A*(10^B).

, 1.23**-2 1.23E-02 , , , "". , , =, =1.23**-2 0.0123.

10**-2 2 ( B ), 0,1.

:

1**-2 => 0.01
1.2**2 => 120
.5**1 => 5