FIX at bottom-right of Excel screen. Know what it means?

B

Bobbert

When ever I open a worksheet the bottom right corner of the screen (by the
CAPS, SCRL, etc alerts) FIX is showing. Does anyone know what is causing
this?
 
G

Gord Dibben

Tools>Options>Edit. "Fixed Decimal Places"

Uncheck it.

This feature allows you to enter 1234 in a cell and it converts to 12.34 or
whatever number of places it is set for.


Gord Dibben Excel MVP
 
Top