Now have to hit the "period" key after entering a number?!?
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.
Also I am on a MAC so I would need to make this fix within the application, not in the system.
thanks
Bookmarks