Now have to hit the "period" key after entering a number?!?

[ZinCT]

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

[dip11]

That sounds like your region settings have changed in Windows. Go to Control Panel and fix them there (setting for handling comma and dots)

[ZinCT]

Thanks, I forgot to mention I'm on a MAC - so this would be a setting within Excel. We don't control commas and periods on a system level. but thank you for replying

[dip11]

The only other thing I can think of is that you can try going to format cells and look at the format that's being applied to them. Maybe its dividing the number by 100

[JosephP]

click excel-preferences, click the 'edit' button in the authoring section and uncheck the 'display this number of decimal places' option