importing file from excel formatting issues.

Question

importing file from excel formatting issues.

i opend an excel file from windows 11 (microsoft home and buisness 2019) , the file opened in numbers (m1 macbook pro max). The issue i have is that the comments (the triangle in the corner of the cell) covers part of the number in the cell. I could not change the color also. I deleted the comment and entered a new comment. I can now change the color, but the comment triangle still covers part of the number in the cell, see attached picture. Any solutions to fix this? Thank you.

MacBook Pro (2020 and later)

Posted on Jan 7, 2022 6:19 PM

Reply

Answer 1

Badunit

Level 7

30,342 points

Jan 7, 2022 6:56 PM in response to confusedconfucius

The comment triangles are a set size. Make all the cells larger and maybe the font, too.

Also, the text is very close to the top of the cell. Making the cells taller would get the numbers into the center of the cells. I don't think the format settings in Numbers provides a way to get the text that close to the top edge of a cell so it is possible that is going to be a problem for you, too.

Reply

Answer 2

Jan 8, 2022 6:25 AM in response to confusedconfucius

Thank you for your help. Used your suggestion and selected all the rows and adjusted the height, this moved the text lower in the cell solving the issue.

Reply

importing file from excel formatting issues.

Similar questions