

If you click on one of the cells, you’ll see that the numbers actually have a hidden apostrophe in front of them, like you see in this screenshot:Īfter spending some time on the internet, I finally found out what is going on. Here is a screenshot illustrating that the numbers look like numbers in their cells: For example, you may want to sort them or use them as part of a calculation and it doesn’t work. The numbers display fine in their cells, but when you try to do something with them, you find that you can’t. You have a spreadsheet that has a column of what you think are numbers in it.
