View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default what is single quotation mark left side of cell for

The single quote tells Excel that what follows is text. For example if you
enter: 123, that is the number 123 and will be right justified. If you
enter '123. That is text amd will be left justified. However, you can still
use the text '123 in computations.

Tyro
..
"Stache02" wrote in message
...
what does a single quoatation mark appear in text cells