Formatting Cells

C

chmartz

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.
 
J

Jimbola

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

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

HTH

J
 
C

chmartz

Thank you so much, I will follow that path.

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

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

HTH

J
Click to expand...
 
Top