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
|