View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Mystery Apostrophe

It tell Excle that the cell's content is to be treated as a TEXT string...
eg if you enter =3+5 in a cell, Excle will assume you wanted to add 5 to 3
and give you 8 but if you enter '=3+5 you will get 3+5 as TEXT in the cell.

You can simply edit the cell, go to the beginning of the value in the cell
and delete it.


"kirkm" wrote:


In the 'edit' area called fx there is - sometimes - an apostrophe
ahead of the text - although this isn't part of the text string in the
cell.

What is it - and how can I get RID of it please ? !!

Thanks - Kirk