I have a couple columns in a spreadsheet I am working on that require a text ' (single quote/apostrophe) to be the first character in the cell.
I can enter the single quote and can see it when editing the cell but the single quote is not displayed on the screen?
Any ideas? I did some searches on this site but could find nothing regarding this. I assume Excel is treating it as some sort of control character. I changed the column type to text...no help. If I put a space in front of the quote it does work but I would rather not have this space in the cell.
Bookmarks