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

HI on a macbook excel 2008 every time i enter a number

This answer was rated:

on a macbook
excel 2008
every time i enter a number it divides it by 100
so if i enter 1 then 0.01 shows in the cell
i have tried to change cell formatting - no soln

plse help



Ok you need to uncheck the box "Fixed decimals" under the Edit tab in your Excel Options.


Hope this helps. Let me know if you have any questions.


John D and 3 other Mac Specialists are ready to help you
Customer: replied 7 years ago.
hi ,

thanks for prompt response.

I understand your answer, but cannot find the checkbox i am using mac 2008 home edition office, no checkbox in edit