While working on an important spreadsheet, you might see a small green triangle in a cell. Hovering over it shows the message: “The number in this cell is formatted as text or preceded by an apostrophe.” This warning typically occurs when trying to copy and paste links from another worksheet. Let’s explore the best ways to fix this error effectively.