Solved

Apostrophe in every cell

Posted on 2013-12-10
4
148 Views
Last Modified: 2013-12-10
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
Comment
Question by:cansevin
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
Ashok earned 500 total points
ID: 39708852
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
 
LVL 50

Expert Comment

by:barry houdini
ID: 39708859
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
 
LVL 13

Expert Comment

by:Ashok
ID: 39708861
Cells will work properly.
0
 

Author Closing Comment

by:cansevin
ID: 39708865
Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now