Thread: what is single quotation mark left side of cell for
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default what is single quotation mark left side of cell for
The single quote mark you see in the formula bar denotes the cell is formatted
as text.

The quote mark should not be showing up in the cell or when printing out.

If you have a quote mark showing in the cell, you have entered it by adding two
quote marks and you should two in the formula bar.


Gord Dibben MS Excel MVP


On Fri, 11 Jan 2008 10:12:07 -0800, Stache02
wrote:

what does a single quoatation mark appear in text cells

Reply With QuoteReply With Quote