Formatting Cells

[Guest]

when trying to enter a series of numbers, excel keeps placing a 2 point
decimal. I have selected "general" under format cells, and the display is
showing the decimal point. I have tried selecting "number" and putting the
decimal at "0", but the decimal point won't go away. It is now happening on
old spreadsheets that are protected. I have to place a decimal point at the
end of my numbers so they appear as say an account number.

 

[Guest]

Have your options been changed go to
Tools > Options > Edit (tab)

Is the fixed decimal box checked, if so uncheck it.

HTH

J

 

[Guest]

Thank you so much, I will follow that path.

Have your options been changed go to
Tools > Options > Edit (tab)

Is the fixed decimal box checked, if so uncheck it.

HTH

J