Excel Spreadsheet decimal places

I routinely view Excel spreadsheets on iPhone however after downloading iOs 10, the way decimal places are displayed has changed. Previously if the spreadsheet had been saved with decimal place display setting specifying 2 places or 0 places, when the file opened on iPhone it would also display decimals as saved in Excel file prior to sending. Since iOs 10, decimals are displayed showing the most number of decimals used within the file. So if there is a number entered within a cell using 5 decimal places, all numbers on the sheet will display using 5 places regardless of what the display setting is set to display on the computer. (Even if display is set for only whole numbers, the phone will display 5 decimal places.)

Long story short this makes quickly viewing sheets on iPhone very difficult if not impossible.

iPhone 6s, iOS 10.0.2

Posted on Oct 11, 2016 12:43 PM

Reply

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel Spreadsheet decimal places

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.