All of a sudden I have to hit period after entering a number to get a whole number.
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.
Re: All of a sudden I have to hit period after entering a number to get a whole number.
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1