How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

Using Mac 10.6.4, Excel 2008. In a sheet Ive been working

Customer Question

Using Mac 10.6.4, Excel 2008. In a sheet I've been working on for a week, for some unknown reason, all numbers entered, such as: 111, on shows as 1.11.

Each cell is formatted as Number, 2 decimal places. IF I convert the row to text, enter the values, excel will then show an error, "number stored as text". Clicking on convert to number works. Given the several thousand values in the sheets, that is not a viable fix. Also just checked several other sheets - same exact problem - Assistance Please?
Submitted: 5 years ago.
Category: Mac
Expert:  John D replied 5 years ago.



Open Excel and go to Preferences, then click the Edit tab, and uncheck the box "Fixed decimal"


That should do it


Please feel free to reply if you need further clarification or click Accept if this answers your question fully.


John D and other Mac Specialists are ready to help you
Customer: replied 5 years ago.
It works, but doesn't make much sense - as I've been using excel for weeks without the problem. Any idea why "Display this number of decimal places: 2, should result in changing the value of the input number?
Expert:  John D replied 5 years ago.



Someone must have checked that box (or it may have been checked by a macro that you may have run recently)


As for the reason, some users prefer this option for faster data entry. For example if you use Excel to enter a long list of dollar amounts frequently, instead of typing a decimal in each entry you can set the option on 2 decimals and it will automatically enter the decimal for you (e.g. instead of typing 22.95, you just type 2295)


Hope this helps