Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

Apostrophe in every cell

Every one of my cells starts with an apostrophe. You can't actually see it, in the cell, but when you look double click into the cell, it shows up. I downloaded this from a website.

How do I get rid of it? Is it s problem or will the cells still work properly?

Thanks!
0
cansevin
Asked:
cansevin
  • 2
1 Solution
 
AshokCommented:
That is perfectly normal.
When an apostrophe is there, it means the cell contains TEXT (not a number, not a date, etc).

You do not need to get rid of it.  Think of it as "It is not there".

HTH
Ashok
0
 
barry houdiniCommented:
The apostrophe indicates that the data is to be treated as text - that shouldn't be a problem unless you want to use SUM or some other mathematical functions on the data

regards, barry
0
 
AshokCommented:
Cells will work properly.
0
 
cansevinAuthor Commented:
Thanks!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now