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.

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

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

HTH

J


"chmartz" wrote:

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.

Thank you so much, I will follow that path.

"Jimbola" wrote:

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

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

HTH

J


"chmartz" wrote:

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.