For example, a column that is supposed to display percentile is showing:
9630.00%
9051.00%
1779.00%
9825.00%
7879.00%
8774.00%
462.00%
9754.00%
Are my settings off somewhere?
(Using Calc Version: 5.2.3.2 on Ubuntu 14.04)
If the actual (“unformatted”) value of a cell is 96.3 and the ‘Numbers’ format is set to percentage with two decimal places (code: 0.00" "%) the cell will correctly display 9630.00 %.
Your problem may be caused by an incorrectness either of the way Excel saved the file as xlsx (some sub-versions!) or of the way Calc opened it. The so called file formats are very different and errors will occur.
I don’t think you can fix the problem by changing any settings. If you have an Excel you may open the fila again with it and save it as xls. Probably this can establish a correct understanding.
Otherwise please post the format code displayed for the cells of your “% column” and report what you see if you change the ‘Numbers’ format of one of these cells (showing 9630.00 % e.g.) to ‘General’. If the problem is restricted to some ranges I may be able to describe a fix then.
It looks like you are right. I asked a friend to open the file in Excel, and the values in those columns is actually 96.3 but formatted in a custom format that appears as percentage. I thought there might be something wrong with either calc or my settings but that’s not the case.