Diference between Screen and writing bar

Copper Contributor

Can anyone help me with the anomalous behavior of excel?

The typing bar does not indicate the same value as on the screen.

Example:Excel-problema-en-pantalla.jpg

1 Reply

@ReynosoOJ Well, you entered a calculation of -2,33 to the power of -5. Excel calculates and displays the result. Then you formatted the cell to show the scientific format. What would you expect to see otherwise?

 

It's the same when you enter =2+2, Excel displays 4 in the cell but you still see =2+2 in the formula bar.