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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It means you have fixed decimal settings checked under tools>options>edit
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

READY BAR 2
Screen / Display "TRUE" "FIX" 3
Excell Arrow Keys 1
Scroll Lock mode locked + SCRL blinking 1
Excel Excel spreadsheets opening at top instead of bottom. 4
What is blue symbol bottom right corner of cell 2
SCRL flashing in status bar 14
Missing Sum at Bottom Right Corner 3

Back
Top