Ranking data in Numbers

Question

Level 1

0 points

Ranking data in Numbers

Hello, I recently purchased an iPad 4 and the Numbers application. I normally do my spreadsheet work on a PC with Excel. I copied an employee rankings Excel spreadsheet over to Numbers and was given the following message.

Unsupported formulas were removed. The last calculated values were imported.

Everything in the spreadsheet looks correct except the ranking values are expressed three different ways in the three different columns.

Name Overall Rank Apples Sold Rank Oranges Sold Rank Bananas Sold Rank TOTAL

Mark 1 5.2 300% 2.7 2 5.1 1.00 13

So, even though the formulas are the same in all of the Rank columns, the rank results are expressed in very different ways

Numbers-OTHER, iOS 6.1.3

Posted on Apr 18, 2013 4:33 PM

Reply

Answer 1

Barry

Level 9

59,861 points

Apr 18, 2013 11:51 PM in response to SuperGeon

Hi SG,

Looks like they're just formatted differently.

Select each column listing ranks, open the Inspector, choose the Cell Inspector.

Use the popup menu to select Number as the format, then set the number of decimal places to none.

NOTE: Reply is specific to Numbers for Mac OS X. The steps should be similar for the iOS version, but the route t the Cell inspector is lkely different.

Regards,

Barry

Reply