Single Quote - Excel 2007

smileanandh Posts 2 Registration date Tuesday December 8, 2009 Status Member Last seen March 24, 2010 - Updated on Jan 31, 2019 at 03:39 PM
 FLAWLESSVW - Apr 6, 2015 at 06:51 PM

Does anyone know what the single quotation mark ' means when entered at the beginning of a cell?

I notice that the quotation mark does not actually appear in the cell. In other words, it appears in the formula bar when entered but disappears from the cell once you press enter.

I want to to get rid of that. I need a single quote at the beginning!

System Configuration: Windows XP / Safari 532.5

6 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Updated on Jan 31, 2019 at 03:40 PM

That means the value being enter is text. It is like if you want to write 001 in a cell, generally Excel would convert it to 1 but if you write it as '001 it will stay as 001.