lincris
Level 2 (165 points)
iOS Apps

Q: Excel converts whole numerals to decimal

I am using an old Excel spread sheet and have created some new entries.  However, whenever I add a number into a new cell, such as the year 2016 or the number 5, it converts them to decimal places.  For example, 2016 becomes 20.16 and 5 becomes 0.05.  Using the Number or General commands to reduce the decimal places to zero (0), results in 2016 becoming 20 and 5 becoming zero (0).  Any ideas on how to correct this please?

 

Excel 15.27 on OS X 10.11.6.

iMac, OS X Mountain Lion (10.8.2)

Posted on Oct 20, 2016 10:08 PM

Close
lincris

Q: Excel converts whole numerals to decimal

  • All replies
  • Helpful answers

  • by Peggy,

    Peggy Peggy Oct 21, 2016 9:11 AM in response to lincris
    Level 8 (38,947 points)
    Applications
    Oct 21, 2016 9:11 AM in response to lincris

    Apple's site is for technical questions about Apple-branded hardware & software. The best place to ask questions about third-party hardware &/or software is the manufacturer's web site. In your case that would be Microsoft's Office for Mac forums. Use the drop-down menu on the left to choose the specific sub-forum.

  • by lincris,

    lincris lincris Oct 22, 2016 10:03 PM in response to Peggy
    Level 2 (165 points)
    iOS Apps
    Oct 22, 2016 10:03 PM in response to Peggy

    Yeah, I know Peggy, but I thought there might be someone who'd had a similar problem in the Mac forums.  I posted the same question on the MS Mac forums and fortunately had a quick correct reply.  It turns out it was an Excel>Preferences>Edit error under the >did tab.  A quick uncheck of the offending "Display this number of decimal places" box did the trick.