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
 

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

Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
READY BAR 2
Screen / Display "TRUE" "FIX" 3
Display selected cell at bottom of screen 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Position screen at end of macro 3
What is blue symbol bottom right corner of cell 2
Hidden Excel mystery 0

Top