Can someone help with this. After using excel on and off for 10 years, I now all of a sudden have to hit the period after entering a number to get a whole number. For example if I am in a currency column and type (1,0 then enter) I get ten cents instead of ten dollars. In the past it was reversed in that I had to type (period then 1,0 then enter) to get ten cents and if I typed (1,0 then enter) I would get ten dollars.

Is there a setting I can use to revert back to how it was. I want to type (1,0, enter) and get the dollar amount.

This also works in regular numerical fields. I want to change it back so that I do not have to type a period after entering a number to get a whole number.

thanks